Rounddown function does not work in the XML

Support
1

Dear all,

In a form need to get rounddown value. I used excel rounddown formula in the xlsform. But it gets an error while uploading the form. The main objective of the of my attached xls is to get the year, month, and day of a person calculating from the Brith Day input. Or is there any other way to get a person's year, month, and days.

year_month_day_calculation.xlsx (9.9 KB)

Thanks,
Arif

2

Hello @ARIF_AZAD_KHAN ,

To do any calculation on date fields you have to convert it into integer . You can do that by using decimal-date-time(.) . You can have a look at this here . Hope it helps.

Thanks and Regards,
SGSC.

1 Like