Date Formatting

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

Convert the value you to date and pass it to text function like this

text(date(0,9,25),"ddd mmmm") 

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"
  )
)

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]
  )
)