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.