This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a field with date being written as 'Thursday, July 30, 2015 12:00pm EDT', how do I go about converting it to a standard date time format with timezone information. I don't see any custom date formats in the DateTime Tool. I did try using the DateTimeParse function, but am not getting the desired output which should be something like '2015-07-30 12:00 PM -0500'.
So it turns out this is a surprisingly frustrating question. I think the timezones are going to have to be custom unless anyone has experience with this?
I've uploaded an example of the datetime parsing here. I've parsed out all the information at the start into seperate fields so if you find a lookup source for your timezones, you can add values after. The reference article for the time parsing information is located here. It's quite complete but I don't really trust it. Some of the options don't appear to work as expected.
Anyway, give it a go and let me know what you think.
Using his workflow (RFC date formula) along with a few changes (a bit of regex and formula tools) this will be possible, but as mentioned, surprinsignly a little frustrating due to TimeZone and am/pm (lowercase)
I hate substring, in this situation I like to break up the data into building blocks using the text to column tool, then I just use a simple formula calculation to put the blocks together.
1) feed data into the text to colum tool, the delimter would be the space which would breakout the first part of your date, set the max break out to 3 fields and then put everything else in a 4th field
The result would be Sep 9 2015 would be in 3 fields
2) use the delimiter tool again on the output of the first one, but this time on the 4th field which would contain 1:37:08:000PM, this time set the delimter to :
3) I don't know what final format you need but just use a formula tool (field1) +'/'+ (field2)....... and so one.
To help keep my head straight, I usually put a select tool after each text to column tool and rename the fields accordingly, otherwise you end up with 7+ field with generic headers.