What is the problem? Please be detailed.
This post is linked to the form on the Showcase channel
If I convert the form with XLSForm (online/offline) it gives a validation error.
The sysntax looks correct and if I use the offline converter without validation, it converts the form that works correctly in Collect.
What breaks the validator is the calculation
decimal-date-time(concat(${year}, "-01-01"))
where ${year} is the year extracted from a date.
Another issue is that because there's a variable ${weekofyear} that has the same name of the file, this leads to another error.
What ODK tool and version are you using? And on what device and operating system version?
XLSForm Offline 1.8.1 (Windows 7) and Online 1.3.1, ODK Collect 1.19.0
What steps can we take to reproduce the problem?
Just try to convert the attached form with XLSForm online or offline.
What you have you tried to fix the problem?
Convert with offline without validation works.
Renaming the variable ${weekofyear} and removing the calculation decimal-date-time(concat(${year}, "-01-01")) pass xls passes the validation test.
Anything else we should know or have? If you have a test form or screenshots or logs, attach here.
weekofyear.xls (9.5 KB)