DAY Function



Function Type

Predefined function

Syntax

DAY( <dateValue> )

Description

Returns the day of the month for a date value.

Argument

Description

<dateValue>

Any Date or TimeStamp data type.

Numeric values are treated as date/time values where the fractional part of the number represents time, and the whole part represents a Julian date. Dates formatted as strings are interpreted in the same way as the DATEVALUE function interprets date strings.

Null values are treated as a numeric zero.

Returns

Integer

Example

This example returns the day of the month for the current date.

Day(Now())


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*