there is any way to convert Date in word
something like that 19/05/2019 convert in Nineteenth May Two Thousand Nineteen.
plz help
Solved! Go to Solution.
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
There's no such built-in function available in FormCalc or JavaScript to do so. You will have to create it yourself.
Views
Replies
Total Likes
I have very little knowledge of Javascript
Pls help me to create it
Views
Replies
Total Likes
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
MAGIC Worked.
Thanks a lot.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies