Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How do I create a date field using a text field that has year and month only.

I have a text field that contains year and month only (ex '201801'). How do i create a date field using this text field.   Thanks! Sallee
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Well, in DAX you could do this:

     

    Column = DATE(INT(LEFT([Column1],4)),INT(RIGHT([Column1],2)),1)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, I have this formula

Businessdate = DATE(LEFT([BUS_YEAR_MTH],4),MID([BUS_YEAR_MTH],5,2),1)

 

but it is giving me this error:

Expression.Error: The name 'DATE' wasn't recognized. Make sure it's spelled correctly.

 

Thanks for your help!

Sallee