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
© 2024 Altair Engineering Inc. All Rights Reserved.