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

     

     



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