Progress® Telerik® Reporting R3 2017

Date and Time Functions

Use these functions to calculate date and time values. Their default format is determined by your local computer locale settings.

Other functions

FunctionDescription
Now()Returns the current date and time on the computer processing the report, expressed as the local time.
Quarter(date)Returns the quarter of the month component of a specified date.
Today()Returns the current date on this computer, expressed as the local time.
Date(year, month, day)Returns the date specified by the given year, month and day.
IsLeapYear(year)Returns an indication whether the specified year is a leap year.
DaysInMonth(year, month)Returns the number of days in the specified month and year.
AddYears(date, years)Returns a new DateTime that adds the specified number of years to the value of the specified date.
AddMonths(date, months)Returns a new DateTime that adds the specified number of months to the value of the specified date.
AddDays(date, days)Returns a new DateTime that adds the specified number of days to the value of the specified date.
AddHours(date, hours)Returns a new DateTime that adds the specified number of hours to the value of the specified date.
AddMinutes(date, minutes)Returns a new DateTime that adds the specified number of minutes to the value of the specified date.
AddSeconds(date, seconds)Returns a new DateTime that adds the specified number of seconds to the value of the specified date.
AddMilliseconds(date, milliseconds)Returns a new DateTime that adds the specified number of milliseconds to the value of the specified date.