Day()

Day()

Category: Date

Syntax: Day ( Date )

Parameters: Date ”Any valid date (1/1/0001 “12/31/4000), expression that returns a date, or field that contains a date.

Description: Returns the day of month (1 “31) for any valid date.

Examples:

 Day ( "1/15/2000" ) = 15 

Other functions can be referenced in Day() :

 Day ( Get ( CurrentDate )) 

returns the day of month for today.

Parameters in Day() can be calculated:

 Day ( Get ( CurrentDate ) - 90 ) 

returns the day number for the date 90 days before today, which may not be the same as today's day number.