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
© 2024 Altair Engineering Inc. All Rights Reserved.