DateTime Parse Help!
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
how should i go about update the string "Wed 1Sep21 00:09:06 am" to "Wed 1Sep21 12:09:06 am" ? Ultimately i need the date to be in the format of mm-dd-yy hh:mm:ss (24 hours)
Tried DateTImeParse but it is throwing range error on hours because the formula I used requires the hour element in the string to be in good format (i.e. 1-12) DateTimeParse([string],"%a %d%b%y %I:%M:%S %P")
THank you !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you have midnight as 00, this is already on the 24h format, don't actually need the am at the end. And even the day of the week you can get rid of.
Try this one: DateTimeParse(Substring([Field1],4,15),"%d%b%y %H:%M:%S")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sry my data is that clean - might need this "00" to "12" enrichment so that datetimeparse can actually work. Is there any other alternatives ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @wiseman_21
My take on this. Even if hr is in 1-12 or "00"-"12" it should still work.
Workflow:
Hope this helps : )
