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.

Do you have some feedback for us?

If you have suggestions for improving this article,