End Of

The endOf formula finds the end date/time (in relation to PIT) of the specified attribute at the member or crew level.

Format: endOf (attrName) or endOf (attrName, date format)

The date format is optional; however, if a format is not selected, the default of MM/DD/YYYY HH:MM:SS will be used.

When using a date format, use the following abbreviations:

• mm: for the month

• dd: for the day

• yyyy: for the year

• HH: for the hour (in 24 hour format)

• MM: for the minute

• ss: for the second

The Status keyword may be used in place of attrName to return the start time of a member’s schedule record, based on the PIT’s location.

When the endOf formula is looking at the end time of an employee’s schedule status, the badge will now show the end time of the last working record if the employee has working records that touch each other.

Example: An employee has a shift record from 08:00-17:00 and then a holdover record starting at 17:00. If the point-in-time in Crew Manager is during the employee’s shift record, ARCOS will display the projected end time of the holdover record in the badge.

Note: Status will not work as a keyword at the crew level.

Example Formulas:

• endOf (Supervisor)

• • Shows the point-in-time where “Supervisor” attribute goes from enabled to disabled in MM/DD/YYYY HH:MM:SS format

• endOf (Supervisor, mm/dd HH:MM )

• • Shows the point-in-time where “Supervisor” attribute goes from enabled to disabled in MM/DD HH:MM format

Reminder

The formula, attribute name and data point must be spelled and in the same case as the formula, attribute or data point you are referencing.

E.g. If an attribute is called CrewType, in the formula, you must use CrewType. crewType and CREWTYPE will not reference the CrewType attribute.

---

*Note: Not all companies have all of the items described in the Online Help.

*Please note, the ARCOS online documentation is a living document that is always under review. If you see information that is inconsistent with the behavior in the application, or you do not see a page covering an ARCOS feature you would like to know more about, please contact the ARCOS Support Center.