Hi All
I try to calculate in FormCalc difference between to dates and display result in time format like HH:MM.
I have two date fields formatted by MM/DD/YYYY: satrtDate and endDate. And TextFeild where I expect to get result.
My code for TextField in calculate event:
differenceD = (Date2Num(endDate, "YYYY-MM-DD") - Date2Num(startDate, "YYYY-MM-DD")) * (1000 * 60 * 60 * 24)
$ = Num2GMTime(differenceD, "HH:MM")
But unfortunately I cannot get the result. What is problem in my calculation? How to fix to calculate correctly?
Thanks.