Function: Day

Description

Returns the number of day (1-31) from a date.

Syntax

Day(date)

Arguments

date can be a constant, a date field, an expression that results in a date, or a function that returns a date.

Return value

This function returns a number in the range 1-31.

Calculated field example

If the Ship_Date field contains the value 20010526, the following function will return the value 26: Day(Ship_Date)

Filter/Find example

Records with the dates 19890722, 19920526 or 19940317 in the Ship_Date field can be selected or found using the expression: Day(Ship_Date)>15