Hello everybody !
I'm currently looking for a solution to create a date column (format : mm/aaaa) by using sql formulas on my Elasticube.
Knowing that there are 2 columns in my original Excel File (one for the months : 1 2 3 ... 12), and another column for the years (2015 2016.... 2020), how can i create a single date column (mm/aaaa) ?
First, i wanted to concatenate those two columns, using : CONCAT(l.[Months],'/',l.[Years]) AS Date. But Sisense does'nt accept the '/ ' between the months and the years... and only accept "text" values with CONCAT.
I also tried to use the CreateDate function : CreateDate([Years],[Months]) As date, but an error occured : Function 'CreateDate(int,int)' is not declared..
Does anyone have a solution to this problem ?
Thank you in advance for your help !
Please sign in to leave a comment.