Change date data format from text

[Anonymous]

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.

[Anonymous · Accepted solution]

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]

@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