Hi,
I am receiving date in the format like : 25SEP
I want to format it in this format : 25th September
Is there a way to do it ?
Discussion posts and replies are publicly visible
text(todate(now()), "dd mmmm yyyy")
wont work ... I can receive yesterdays date also ... 24SEP
Hi
Replace now() in above code snippet with received dates.
text(todate("Received Date"), "dd mmmm yyyy")
Does not work
Using todate("25SEP") returns 26/01/2035
a!localVariables( local!date: split(text("Enter the date", "dd mmmm"), " "), concat( local!date[1], a!match( value: tointeger(mod(local!date[1], 10)), equals: 1, then: "st", equals: 2, then: "nd", equals: 3, then: "rd", default: "th" ), char(32), local!date[2] ) )