Function: IsoWeekDay

Description

Returns the number of the day of the week for the given date, where 1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday and 7=Sunday.

Syntax

IsoWeekDay(date)

Arguments

date may be any valid date in the range 1/1/1601-12/31/2400.

Return value

This function returns a number (1-7).

Calculated field example

If the Ship Date field contained the date 10/28/2008, the following expression would return 2 (Tuesday): IsoWeekDay([Ship Date])

Filter/Find example

The following filter expression would select or find records with ship dates that fall only on weekdays: IsoWeekDay([Ship Date])>=1 .And.IsoWeekDay([Ship Date])<=5