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...
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

     

     



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.