WEEKEND()

WEEKEND() returns T if the specified DateTime field value falls on a Saturday or Sunday.

Use WEEKEND() to identify or exclude DateTime field values that occur on weekends.

Function Format

WEEKEND(D)

WEEKEND() returns T if the specified DateTime D falls on a weekend (i.e. Saturday or Sunday), otherwise the function returns F.

Acceptable dates are in the range January 1, 1900 to December 31, 9999.

Examples

Using a date of August 16, 2014:

WEEKEND(‘20140816‘) = T

Using a date of August 14, 2014:

WEEKEND(‘20140814‘) = F