Syntax

day_number = DAYOFWEEK(date)

Arguments

day_number: integer

date: text

Meaning

Parameter date must be a valid date in the Julian (yyyy.ddd, not supported in Axiell Collections), European (dd/mm/yyyy, Collections also supports dd-mm-yyyy), or ISO (yyyy-mm-dd). The American format is not supported. This function returns the number of the day of the date entered, where 0 stands for Sunday, 1 for Monday, ... and 6 for Saturday. For date you can also use 'today' or date$(<code>). The system will then automatically fill in the value that is valid when the ADAPL is executed. It is also possible to combine 'today' or date$(<code>) with a plus or a minus sign followed directly by an integer without space in between (e.g. 'today -10'). This represents the system date plus or minus the number of days stated.

Example

day_number = dayofweek('12/09/1995')

Result

Returns the value 2 for day_number.

See also

DATE$