Configure Date expression
Functions
CURRENTMONTH
| Syntax | CURRENTMONTH() |
| Description | Returns the current month. |
| Example | CURRENTMONTH() |
CURRENTYEAR
| Syntax | CURRENTYEAR() |
| Description | Returns the current year. |
| Example | CURRENTYEAR() |
DATEADD
| Syntax | DATEADD(datepart,numeric_expression, date_expression) |
| Description | Adds a time/date interval to the specified date. |
| Example | Refer to this section for examples |
DATESUB
| Syntax | DATESUB(numeric_expression, date_expression) |
| Description | Returns the date subtracted from the specified date. |
| Example | DATESUB(7, [OrderDate]) |
DAY
| Syntax | DAY(date_expression) |
| Description | Returns a numeric value representing the day part of the specified date. |
| Example | DAY([OrderDate]) |
DAYDIFF
| Syntax | DAYDIFF(start_date_expression, end_date_expression) |
| Description | Returns a numeric value representing the difference between two specified dates. |
| Example | DAYDIFF(MAX([OrderDate]), ‘1988-08-08’) |
HOUR
| Syntax | HOUR(date_expression) |
| Description | Returns the hour of the given date as an integer. |
| Example | HOUR([OrderDate]) |
MINUTE
| Syntax | MINUTE(date_expression) |
| Description | Returns a numeric value representing the minute part of the date resulted from the specified date expression. |
| Example | MINUTE([OrderDate]) |
MONTH
| Syntax | MONTH(date_expression) |
| Description | Returns a numeric value representing the month part of the date resulted from specified date expression. |
| Example | MONTH([OrderDate]) |
NOW
| Syntax | NOW() |
| Description | Returns the current date and time. |
| Example | NOW() |
PREVIOUSDATE
| Syntax | PREVIOUSDATE() |
| Description | Returns the previous date. |
| Example | PREVIOUSDATE() |
PREVIOUSMONTH
| Syntax | PREVIOUSMONTH() |
| Description | Returns the previous month. |
| Example | PREVIOUSMONTH() |
PREVIOUSYEAR
| Syntax | PREVIOUSYEAR() |
| Description | Returns the previous year. |
| Example | PREVIOUSYEAR() |
TODAY
| Syntax | TODAY() |
| Description | Returns the current date. |
| Example | TODAY() |
YESTERDAY
| Syntax | YESTERDAY() |
| Description | Returns the yesterday date. |
| Example | YESTERDAY() |
YEAR
| Syntax | YEAR(date_expression) |
| Description | Returns a numeric value representing the year part of the date resulting from the specified date expression. |
| Example | YEAR([OrderDate]) |
DATENAME
| Syntax | DATENAME(date_part, date_expression) |
| Description | Returns a string representing the specified date part of the given date expression. |
| Example | DATENAME(“day”, [OrderDate]) |
| Description | Returns a string represents using CONCAT and DATENAME functions for the specified date expression. |
| Example | CONCAT(DATEPART("day",[Date]),'-',DATENAME("month",[Date]),'-',DATENAME("year",[Date])) |
DATEPART
| Syntax | DATEPART(date_part, date_expression) |
| Description | Returns an integer value representing the specified date part of the given date expression. |
| Example | DATEPART(“year”, MAX([OrderDate])) |
| Description | Returns a string represents using CONCAT and DATEPART functions for the specified time expression. |
| Example | CONCAT(DATEPART("hour",[Date]),'.',DATEPART("minute",[Date]),'.',DATEPART("second",[Date])) |
MAX
| Syntax | MAX(expression) |
| Description | Returns the maximum value in the given expression. |
| Example | MAX([OrderDate]) |
MIN
| Syntax | MIN(expression) |
| Description | Returns the minimum value in the given expression. |
| Example | MIN([OrderDate]) |