Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert Date and time to UTC

rdelmund
7 - Meteor

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!

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @rdelmund 

 

Try this out:

WF.PNG

 

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
7 - Meteor

Thanks Thableaus this is very helpful

Labels