Convert date in words

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

25-09-2019

there is any way to convert Date in word

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

plz help

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

29-09-2019

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

Answers (3)

Answers (3)

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

29-09-2019

MAGIC Worked.

Thanks a lot.

Avatar

Avatar

aka44356106

Avatar

aka44356106

aka44356106

25-09-2019

I have very little knowledge of Javascript

Pls help me to create it

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

25-09-2019

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