    |
|
Returns a part from a date/time value as an integer.
Syntax
DatePart("IntervalType", "DateTimeString")
Arguments
| Argument | Description |
|---|---|
| IntervalType | Time interval type. |
| DateTimeString | Any date/time expression. See Date/time format examples for valid formats. |
| String | Interval type | Returns: |
|---|---|---|
| d | Day | Day of month (1-31) |
| y | Day of year | Day of year (1-366) |
| h | Hour | Hour (0-23) |
| n | Minute | Minute (0-59) |
| m | Month | Month (1-12) |
| q | Quarter | Calendar quarter (1-4) |
| s | Second | Second (0-59) |
| w | Weekday | Day of week (1-7) |
| ww | Week of year | Week of year (1-53) |
| yyyy | Year | Year |
Return value
| Value | Description |
|---|---|
| Value | Integer that corresponds with the part of the date/time value. |
Example
DayOfYear = DatePart("y", Now())
| |
|