ShiftStart()

Format

ShiftStart(Time [,Site] [,ShiftPattern])

Returns

Returns the time of the start of the shift occurring on or before the provided Time.

The site and shift patterns are optional inputs.  If these parameters are not specified, then the Default Site and the Default Shift Pattern of that site will be used. 

Inputs

Time: The time from which to calculate the start of the shift.
Behaviour: Required
Dimension: Collection, SingleValue, MultiCollection
Valid data types: DateTime, Decimal, Integer, String

Note: You can use the Time() function to use a valid DateTime argument.

Site: Name of the site which contains the shift pattern to use. If this parameter is null or empty string, the default site will be used.
Behaviour: Optional
Dimensions: SingleValue
Valid data types: Null, String

ShiftPattern: Name of the shift pattern to use. If this parameter is null or empty string, the default shift pattern will be used.
Behaviour: Optional
Dimensions: SingleValue
Valid data types: Null, String

How to format data types

Examples

Expression: ShiftStart(Time())
Result: Returns the start time of the shift occurring on or before the provided Time using the default shift pattern of the default site.

Expression: ShiftStart(Time(), 'Perth', 'Operations')
Result: Returns the start time of the shift occurring on or before the provided Time using the 'Operations' shift pattern of the 'Perth' site.

Expression: ShiftStart(Time(), null, 'Operations')
Result: Returns the start time of the shift occurring on or before the provided Time using the 'Operations' shift pattern of the default site.

Expression: Sum_Sampled({TruckLoadEvents}, ShiftStart(Time(), 'Perth', 'Operations'), ShiftEnd(Time(), 'Perth', 'Operations'))
Result: Returns the number of truck load events during the Operations shift of the Perth site.

Release History

  • ShiftStart() 4.10.2
    • Added optional parameters to specify a site and shift pattern to be used in the calculation.
  • ShiftStart() 4.6.5
    • Changed Time parameter to support MultiCollection values.
  • ShiftStart() 4.0
    • Initial version

Comments are closed