List of date functions
The following table describes the DateFunction values that you can use with fields that have a DateTime data type. You can query based on a property of the date instead of the date itself. The calculation depends on the TimeZoneUsed parameter. Possible time zone values are Local or Utc. When Local is used, the user’s time zone offset is considered.
| Function name | Code | Description |
|---|---|---|
| Year | 1 | The four-digit year part of the date. |
| Month | 2 | The month part of the date from 1 to 12. |
| Day | 3 | The day part of the date from 1 to 31. |
| WeekDay | 4 | The day of the week from 1 to 7. For example, 1 for Sunday, 2 for Monday, and so on. |
| DaysPassed | 5 | The number of days that have passed until now. |
| HoursPassed | 6 | The number of hours that have passed until now. |
| MinutesPassed | 7 | The number of minutes that have passed until now. |
If you have suggestions for improving this article, let us know!