Date Formatting

Question

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 ?

Mathieu Drouin · Answer

a!localVariables(
 local!dateTextValue: "SEP25",
 local!months: {
 "JAN",
 "FEB",
 "MAR",
 "APR",
 "MAY",
 "JUN",
 "JUL",
 "AUG",
 "SEP",
 "OCT",
 "NOV",
 "DEC"
 },
 local!monthKey: left(local!dateTextValue, 3),
 local!month: wherecontains(local!monthKey, local!months),
 local!day: mid(
 local!dateTextValue,
 4,
 len(local!dateTextValue) - 3
 ),
 text(
 date(year(now()), local!month, local!day),
 "mmmm ddd"
 )
)

anmolvijayvergiya · Answer

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]
 )
) Try this for once.

anmolvijayvergiya · Answer

text(todate(now()), "dd mmmm yyyy")

Geetha Srikakolapu · Answer

Convert the value you to date and pass it to text function like this text(date(0,9,25),"ddd mmmm") , as you don't want year just mentioned 0 in place of year when executing above you will get output as 25th September

Date Formatting

Top Replies