Change number into date

[i_stanescu_ro]

Hi guys

I have a column with numbers with this format:

19990927

I need to change it to a date format, like this: 09.27.1999 or 27.09.1999 or something like this..

Can I pls ask for your help?

Thanks so much for your time!

[Arul · Accepted solution]

@i_stanescu_ro ,

try this in calculated column,

New Date (Calculated Column) = 
VAR _year = LEFT(Test[Date],4)
VAR _month = MID(Test[Date],5,2)
VAR _day = RIGHT(Test[Date],2)
VAR _date = DATE(_year,_month,_day)
RETURN _date

[i_stanescu_ro]

Thanks so much!

[Fowmy]

@i_stanescu_ro 

Create a calculated column, suppose your data is in a column called  TextData

var __Date = TABLENAME[TEXTDATA]

return

	DATE( INT(LEFT(__Date,4)) ,  INT(MID(__Date,5,2)) ,  INT(RIGHT(__Date,2)) )

[i_stanescu_ro]

Thanks so much!