Workday() mvSQL database function in Jitterbit App Builder¶
Summary¶
Returns 1 if date is a weekday (Monday-Friday), 0 otherwise.
Syntax¶
WORKDAY(<date>)
Parameters¶
date¶
The date to evaluate.
Returns¶
1 if date is a weekday (M-F), 0 otherwise.
Examples¶
WORKDAY('05/11/15')
Returns
1
since 05/11/15 was a Monday.