Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Need to convert text to date

Hi,   I have a text field with the following   August 3, 2018 10:58 AM   I need to convert it to a date function. so it reads 03/08/2018    
Need Help
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi Anonymous,

     

    Didi you try in M with the date function ? Or in Dax the Format function 

     

    Something like this ( where Date is my text column ):

     

    = Table.TransformColumnTypes(Source,{{"Date", type date}})

    Please if it does not work let us know I will try another approach.

     

    Ninter

Interkoubess's avatar
Interkoubess
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Anonymous,

 

Didi you try in M with the date function ? Or in Dax the Format function 

 

Something like this ( where Date is my text column ):

 

= Table.TransformColumnTypes(Source,{{"Date", type date}})

Please if it does not work let us know I will try another approach.

 

Ninter