Expand my Community achievements bar.

Adobe Summit 2025: AEM Session Recordings Are Live! Missed a session or want to revisit your favorites? Watch the latest recordings now.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Convert date in words

Avatar

Level 4

there is any way to convert Date in word

something like that   19/05/2019 convert in Nineteenth May Two Thousand Nineteen.

plz help

1 Accepted Solution

Avatar

Correct answer by
Level 10

You can use FormCalc to convert the date into words.

Put in into the exit event of the date field.

if (not $.isNull) then

  var input = Date2Num($.formattedValue, "DD.MM.YYYY")

  var day = Choose(Num2Date(input, "D"), "First", "Second", "Third", "Fourth", "Fifth", "Sixth", "Seventh", "Eighth", "Ninth", "Tenth", "Eleventh", "Twelfth", "Thirteenth", "Fourteenth", "Fifthteenth", "Sixteenth", "Seventeenth", "Eighteenth", "Nineteenth", "Twentieth", "Twenty-first", "Twenty-second", "Twenty-third", "Twenty-fourth", "Twenty-fifth", "Twenty-sixth", "Twenty-seventh", "Twenty-eighth", "Twenty-ninth", "Thirtieth", "Thirty-first")

  var month = Num2Date(input, "MMMM")

  var year = WordNum(Num2Date(input, "YYYY"), 0)

  TextField1 = Concat(day, " ", month, " ", year)

endif

View solution in original post

4 Replies

Avatar

Level 10

There's no such built-in function available in FormCalc or JavaScript to do so. You will have to create it yourself.

Avatar

Level 4

I have very little knowledge of Javascript

Pls help me to create it

Avatar

Correct answer by
Level 10

You can use FormCalc to convert the date into words.

Put in into the exit event of the date field.

if (not $.isNull) then

  var input = Date2Num($.formattedValue, "DD.MM.YYYY")

  var day = Choose(Num2Date(input, "D"), "First", "Second", "Third", "Fourth", "Fifth", "Sixth", "Seventh", "Eighth", "Ninth", "Tenth", "Eleventh", "Twelfth", "Thirteenth", "Fourteenth", "Fifthteenth", "Sixteenth", "Seventeenth", "Eighteenth", "Nineteenth", "Twentieth", "Twenty-first", "Twenty-second", "Twenty-third", "Twenty-fourth", "Twenty-fifth", "Twenty-sixth", "Twenty-seventh", "Twenty-eighth", "Twenty-ninth", "Thirtieth", "Thirty-first")

  var month = Num2Date(input, "MMMM")

  var year = WordNum(Num2Date(input, "YYYY"), 0)

  TextField1 = Concat(day, " ", month, " ", year)

endif

Avatar

Level 4

MAGIC Worked.

Thanks a lot.