Date Functions

Envision provides a variety of date functions.

EXTRACTYEAR

Extracts the year the from the Date dimension.

Syntax

EXTRACTYEAR([dateDimension])

Example

EXTRACTYEAR([requiredDate])

EXTRACTMONTH

Extracts the month from the Date Dimension.

Syntax

EXTRACTMONTH([dateDimension])

Example

EXTRACTMONTH([requiredDate])

EXTRACTDAY

Extracts the day from the Date Dimension.

Syntax

EXTRACTDAY([dateDimension])

Example

EXTRACTDAY([requiredDate])

EXTRACTDATE

Extracts the date from the Date Dimension.

Syntax

EXTRACTDATE([dateDimension])

Example

EXTRACTDATE([requiredDate])

EXTRACTHOUR

Extracts the hour from the Date Dimension.

Syntax

EXTRACTHOUR([dateDimension])

Example

EXTRACTHOUR([Sale_Time])

EXTRACTMINUTE

Extracts the minutes from the Date Dimension.

Syntax

EXTRACTMINUTE([dateDimension])

Example

EXTRACTMINUTE([Sale_Time])

EXTRACTSECOND

Extracts the seconds from the Date Dimension.

Syntax

EXTRACTSECOND([dateDimension])

Example

EXTRACTSECOND([Sale_Time])

ISYTD

Returns  ‘true’ for those records that have value (the Date Dimension’s value) between the start of the year and today, and ‘false’ otherwise. Takes only the date Dimension as argument.

Syntax

ISYTD([dateDimension])

Example

ISYTD([requiredDate])