Function Description
| Category | Description |
|---|---|
| Syntax | DAY(date) |
| Function | Returns the day value from a specified date. |
| Parameter | date: a specified date value Only date or datetime values are supported. |
| Number of Parameters | 1 |
| Parameter Type | Date |
| Return Value Type | Number from 1 to 31 |
Examples
| Formula | Result |
|---|---|
DAY(DATE(2000,1,1)) | 1 |
DAY(TODATE("1999-01-02")) | 2 |
More Examples
For example, you can use DAY to get the day value from Start Time.
