Advantage Expression Engine function that returns the ISO 8601 week number of a date value

 

Syntax

ISOWEEK( <dDate> ) -> nISOWeek

 

Parameters

<dDate>  A date value to convert.

 

Return Values

ISOWEEK() returns a number in the range of 1 to 53 as an integer numeric value.  If the time or timestamp argument is empty, ISOWEEK() returns zero.

 

Remarks

ISOWEEK() is a date conversion function used to return the ISO 8601 week number of a date value.

 

Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions.

 

See Also

WEEK()

YEAR()

MONTH()

DAY()

QUARTER()