{"id":10326,"date":"2016-02-26T11:37:12","date_gmt":"2016-02-26T03:37:12","guid":{"rendered":"http:\/\/localhost\/help\/p2-server\/calculations\/shiftend\/"},"modified":"2024-08-15T10:31:31","modified_gmt":"2024-08-15T02:31:31","slug":"shiftend","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/shiftend\/","title":{"rendered":"ShiftEnd()"},"content":{"rendered":"\n

Format<\/span><\/h2>\n

ShiftEnd(Time\u00a0[,Site] [,ShiftPattern])<\/strong><\/p>\n

Returns<\/span><\/span><\/h2>\n

Returns the time of the end\u00a0of the shift occurring on or before the provided Time<\/em>.<\/p>\n

The site and shift patterns are optional inputs.\u00a0 If these parameters are not specified, then the Default Site and the Default Shift Pattern of that site will be used.\u00a0<\/p>\n

Inputs<\/h2>\n

Time<\/strong>: The time from which to calculate the end\u00a0of the shift.
\nBehaviour: Required
\nDimension: Collection, SingleValue, MultiCollection
\nValid data types: DateTime, Decimal, Integer, String<\/p>\n

Note: You can use the Time<\/a>() function to use a valid DateTime argument.<\/p>\n

Site:\u00a0<\/b>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.
\nBehaviour: Optional
\nDimensions: SingleValue
\nValid data types: Null, String<\/p>\n

ShiftPattern:\u00a0<\/b>Name of the shift pattern to use. If this parameter is null or empty string, the default shift pattern will be used.
\nBehaviour: Optional
\nDimensions: SingleValue
\nValid data types: Null, String<\/p>\n

How to format data types<\/a><\/p>\n

Examples<\/h2>\n

Expression: ShiftEnd(Time())<\/span>
\nResult: Returns the end time of the shift occurring on or before the provided Time using the default shift pattern of the default site.<\/p>\n

Expression: ShiftEnd(Time(), 'Perth', 'Operations')<\/span>
\nResult: Returns the end time of the shift occurring on or before the provided Time using the 'Operations' shift pattern of the 'Perth' site.<\/p>\n

Expression: ShiftEnd(Time(), null, 'Operations')<\/span>
\nResult: Returns the end time of the shift occurring on or before the provided Time using the 'Operations' shift pattern of the default site.<\/p>\n

Release History<\/span><\/h2>\n