I am trying to extract the DAY, MONTH, YEAR from a date column from my date column to create a dim_date table in my model. Currently my code goes as follows:SELECTDISTINCT birthdate AS Date,YEAR(birthdate) AS Year,MONTH(birthdate) AS Month,DAY(birthdate) AS DayFROM FACT_table UNIONSELECTDISTINCT hire_date AS Date,YEAR(hire_date) AS Year,MONTH(hire_date) AS Month,DAY(hire_date) AS DayFROM FACT_tableI get this error: Function 'YEAR(DateTime)' is not declared. What is the right synta...

Hey Astroraf are you doing this in a custom table (green node in the elasticube)? If so the syntax is GETYEAR(yourdate),GETMONTH(yourdate),GETDAY(yourdate)

Extract Date Format from Date Column using Extract? | Help and How-To

MoreDiscussions

Extract Date Format from Date Column using Extract? | Help and How-To | Sisense Community