List of ER functions in the Date and time category
Electronic reporting (ER) date and time functions can be used to extract information from date and time values, and to perform operations on them. This article provides a summary of these functions.
List of supported functions
| Function | Description |
|---|---|
| AddDays | This function returns a DateTime value that is the specified number of days before or after a specified start date. |
| ChangeTimeZone | This function returns a DateTime value that is converted from a given date/time value in one time zone to a date/time value in another time zone. |
| DateFormat | This function returns a String value that presents a given date value as text in the specified format and in an optionally specified culture. |
| DateTimeFormat | This function returns a String value that presents a given date/time value as text in the specified format and in an optionally specified culture. |
| DateTimeValue | This function returns a DateTime value that is converted from a given text value in the specified format and in an optionally specified culture to a date/time value. |
| DateToDateTime | This function returns a DateTime value that is converted from a given date value to a date/time value in Coordinated Universal Time (Greenwich Mean Time [GMT]). |
| DateValue | This function returns a Date value that is converted from a given text value in the specified format and in an optionally specified culture to a date value. |
| DayOfYear | This function returns an Integer value that represents the number of days between January 1 and the specified date. |
| Days | This function returns an Integer value that represents the number of days between one specified date and a second specified date. |
| Now | This function returns a DateTime value that represents the current application server date and time. |
| NullDate | This function returns a Date value that represents the null date (January 1, 1900). |
| NullDateTime | This function returns a DateTime value that represents the null date/time value (January 1, 1900) in Coordinated Universal Time. |
| SessionNow | This function returns a DateTime value that represents the current application session date and time. |
| SessionToday | This function returns a Date value that represents the current application session date. |
| Today | This function returns a Date value that represents the current application server date. |
| WeekNum | This function returns an Integer value that represents the week of the year. |
Additional resources
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for