Convert date time with time zone to Epoch time

[gcarmich]

I have a date field in my data in the format of:

Wed Jul 26 18:33:05 EDT 2023

I want to convert this to Epoch time to align with other datasets.

I am thinking to use DateTime() to convert to a base time format

then use DateTimeDiff(time_date_timezone_field,'1970-01-01 00:00:00', 'sec')

For DateTIme I trieddy MMM dd HH:mm:ss %Z yyyy but I get a null result.

How can I account for the time zone by acronym in the conversion?

Thanks,
Gil

[alexnajm]

%Z or %z is not supported - DateTime Functions | Alteryx Help

[lwolfie]

I don't know that alteryx converts time zones.  But if you want to eliminate the time zone, you could use regex to remove it and then convert it to date time.

[binuacs · Accepted solution]

@gcarmich One of doing this

[gcarmich]

This approach might be adaptable to adjust other time zone depending on the time zone indicator.  I'll look into it. Thank you.