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

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