Forum Discussion

javieezy's avatar
javieezy
Helper I
5 years ago
Solved

Date Time problem

Dear all, 

 

I'm facing a problem now as I input the data from Excel, the column "ATA" shows as Text instead of Date/Time (as "ATD) and cannot be shown as Date/Time. 

 

But from Excel this two columns are in the same format and can even do calculations. 

 

Any help would be appreciated. 

 

Br, 

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    javieezy 

    The problem with the column ATA is, it has ":"  at the end, do the following.
    Go to: Transform > Extract > Text Before Delimiter and choose the options as I have done


    Then change the column type to Date/Time.
    Done

     

     



2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    javieezy 

    The problem with the column ATA is, it has ":"  at the end, do the following.
    Go to: Transform > Extract > Text Before Delimiter and choose the options as I have done


    Then change the column type to Date/Time.
    Done

     

     



  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    javieezy Can you share the file or at least the code from Advanced Editor in Power Query Editor? Almost looks like the first column is getting truncated for some reason.