Skip to main content Skip to complementary content

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.



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)

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!