Forum Discussion

i_stanescu_ro's avatar
i_stanescu_ro
Helper I
2 years ago
Solved

Change number into date

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 yo...
Need Help
  • Arul's avatar
    Arul
    2 years ago

    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
Arul's avatar
Arul
Super User
2 years ago

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's avatar
    i_stanescu_ro
    Helper I
    2 years ago

    Thanks so much!