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]) |
Thank you for your feedback and comments.We will rectify this as soon as possible!