Help with DateTime conversions in 10.6

[mattlukoff]

Hello,

Can anyone help with the attached two DateTime conversion questions? Keep in mind that I'm still limited to using v 10.6 only so any solution will need to work with those features.

[jrgo]

@mattlukoff,

Can you attach your input file? Only your workflow came through.

[mattlukoff]

@jrgo yes! sorry about that. See attached.

[jrgo · Accepted solution]

@mattlukoff,

See attached. The timezone question though, this one would be harder to do because it's not known what timezone the time shown is currently in. I'm demonstrating an option to 'add' an hour to the current time.

 

Hope this helps!

Best,

Jimmy

[jrgo]

@mattlukoff

Also, https://help.alteryx.com/10.6/index.htm#Reference/DateTimeFunctions.htm contains all of the datetime functions and date part specifiers to parse into (or format out of) a date/time field.