LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sozdemir

Hello LavaStorm experts,

I just started using LavaStorm and I couldn't figure out how to convert a string to valid timestamp:

Here is my data and it is stored under column name of "Date" - and it has string values which are similar to this one:

"2/9/2015 15:36 PM"
"2/9/2015 8:36 AM"

Any help is much appreciated.

Thank you.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

First split the string using space as the delimiter, then parse the date and time separately. I ignored the AM/PM since it's already captured by the 24-hour-clock format.
Attachments:
DateTime.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sozdemir

Awesome.

Thank you so much.