Convert Date and time to UTC

[rdelmund]

Hi, 

Need your help to convert the below dates (String format) to UTC. I tried to convert the string to date format however i don't know what's syntax to be used for AM/PM for DateTime Tool.

Once converted to UTC, I need to have this date format "YYYY-MM-DD" or "2019-01-22" for example. 

Transaction Date

Tue 22 Jan 2019, 10:03:04 pm

Tue 22 Jan 2019, 10:48:04 pm

Wed 23 Jan 2019, 12:04:20 am

Wed 23 Jan 2019, 10:01:37 pm

Thu 24 Jan 2019,  2:02:41 am

Thu 24 Jan 2019, 10:56:25 pm

Tue 29 Jan 2019, 10:09:54 pm

Thank you in advance!

[Thableaus · Accepted solution]

Hi @rdelmund 

Try this out:

Just to be clear, DateTimeToUTC considers your local system time zone. So results may change depending where you are (I'm in Brazil).

Cheers,

[rdelmund]

Thanks Thableaus this is very helpful