Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Change date data format from text

Hello there,

 

I'm trying to change the text here 13-Feb-20 7:14:51 AM in a column to 13/02/2020 type date as a new column. Do you guys know any easy code that I can do? I cant use power query as the data is really big and jammed my laptop.

 

Thank you.

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Create a calculated column.

    Date = [Text]

     

    Then change the data type as follows.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    You add a column in the model as follows and change the format to Date fro the ribbon.

     

    New Date = INT([Date])

    or

    New Date = DATE(YEAR([Date]), MONTH([Date]), DAY([Date]))

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Create a calculated column.

    Date = [Text]

     

    Then change the data type as follows.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.