Split a field into Time & Date

[Brawlstrogg]

Hello folks,

I've got a datafield called DateTime where the format is as follows;

11/28/17 1:00:00 AM

11/28/17 1:30:00 AM

....

11/28/17 1:00:00 PM

11/28/17 1:30:00 PM

I've tried about twenty different combinations of formatting and parsing the data but can't seem to get any to work. Ideally what I'd like is as below;

DateTime	Date	Time
11/28/17 1:00:00 AM	11/28/2017	01:00
11/28/17 1:30:00 AM	11/28/2017	01:30
...	...	...
11/28/17 1:00:00 PM	11/28/2017	13:00
11/28/17 1:30:00 PM	11/28/2017	13:30

So a split down the middle and then the time reverting to a 24 hour clock, but I simply am being dense and can't figure it out.

Any help would be really appreciated!

[vishwa_0308 · Accepted solution]

Hi @Brawlstrogg,

I have tried to figure out your solution and hope this will serve the purpose. Please try the attached workflow and let me know.

Best,

Vishwa

[Brawlstrogg]

Nice one Vishwa. Works like a charm.

Thanks for your help!

B.

[Kenda]

@Brawlstrogg Another option would be to add a formula creating a field called Date with the following expression:

REGEX_Replace([DateTime], "(.*?)\s.*", "$1")

and a second field called Time with the following expression:

DateTimeParse(REGEX_Replace([DateTime], "(.*?)\s(.*)", "$2"),"%X")

Hope this helps and gives you some exposure to some new formulas you may not have ever used before!

[Brawlstrogg]

Always looking to learn more formulas!

Thanks very much!