Using Working Patterns

The Working Patterns screen displays data from an employees working calendar.

Option	Details
Date	Displays the date and can be used to query between certain date rages.
Calendar Name	Displays the Working Calendar name.
Day Start	Displays the time the working day starts.
Day End	Displays the time the working day ends.
Duration	Displays the total duration in minutes. A formula can be used to turn this number into hours.
Is a Bank Holiday	Displays 1 if the date is a bank holiday and 0 if it is not.
Has Booked Full Day	Displays 1 if the date is any type of absence and 0 if no absence.
Week Day	Displays a number for the day of the week. Sunday being 1 as it's the start of the week.

 

Formulas

The below two formulas can give you the days of the week or a weekend/week day split.

CASE

WHEN [Week Day] = 1 THEN 'Sunday'

WHEN [Week Day] = 2 THEN 'Monday'

WHEN [Week Day] = 3 THEN 'Tuesday'

WHEN [Week Day] = 4 THEN 'Wednesday'

WHEN [Week Day] = 5 THEN 'Thursday'

WHEN [Week Day] = 6 THEN 'Friday'

WHEN [Week Day] = 7 THEN 'Saturday'

ELSE ' '

END

 

CASE

WHEN [Week Day] = 1 THEN 'Weekend'

WHEN [Week Day] = 7 THEN 'Weekend'

ELSE 'Week Day '

END