Text with (Date Time UTC) to Date

[Anonymous]

Hi guys, 

I've the following column: 

Resolutiondate

2018-10-29T21:09:54.000-0200

2018-10-29T21:10:01.000-0200

2018-10-10T11:02:44.000-0300

2018-10-10T11:02:49.000-0300

2018-10-10T11:02:54.000-0300

2018-10-10T11:02:59.000-0300

2018-10-10T11:03:05.000-0300

I'd like to transform into date only using dax.

could you help me?

Thanks!!

[Anonymous · Accepted solution]

You can use that formula if you want to create a new formatted date column. If you are comfortable losing the timestamp you dont need DAX.

'Data' --> 'Modeling' --> 'Format' --> 'Date/Time'

[Anonymous]

=FORMAT(<value>, "MM-dd-YYYY") 

Also you can refer to the links below for additional formatting options

https://docs.microsoft.com/en-us/dax/format-function-dax

https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function

[Anonymous]

It doesn't work