Convert date text into another format

Question

How to convert a date text into another format? From Apr 01 2015 3:07:54 AM EDT to 4/1/2015 3:07 AM EDT 
 OriginalPostID-143913 
 OriginalPostID-143913

Stefan Helzle · Answer

There is no built in reverse parsing of date strings. But the following snippet should get you started. 
 a!localVariables(
 local!input: "July 01, 2021",
 local!monthStrings: text(eomonth(date(2020, 1, 1), enumerate(12)), "mmmm"),
 local!parts: split(local!input, " "),
 userdate(
 local!parts[3],
 lookup(local!monthStrings, local!parts[1]),
 tointeger(local!parts[2])
 )
)

Convert date text into another format

Top Replies