Expand my Community achievements bar.

SOLVED

## Convert date in words

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

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`
4 Replies

Level 10

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

Level 4

I have very little knowledge of Javascript

Pls help me to create it

`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`