Skip to main content
Close announcements banner

day - script and chart function

This function returns an integer representing the day when the fraction of the expression is interpreted as a date according to the standard number interpretation.

The function returns the day of the month for a particular date. It is commonly used to derive a day field as part of a calendar dimension.

Syntax:  

day(expression)

Return data type: integer

Function examples
Example Result

day( 1971-10-12 )

returns 12
day( 35648 ) returns 6, because 35648 = 1997-08-06

Example 1 – DateFormat dataset (script)

Example 2 – ANSI dates (script)

Example 3 – Unformatted dates (script)

Example 4 – Calculating expiry month (chart)