संपादित करें

इसके माध्यम से साझा किया गया


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

Electronic Reporting overview

Formula designer in Electronic reporting

Electronic reporting formula language