Day()

Category: Date

Parameters:

DateAny valid date (1/1/000112/31/4000), expression that returns a date, or field that contains a date.

Data type returned: Number

Description:

Returns the day of month (131) 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.