1. What is the problem? Be very detailed.
I built a form in 2021 to collect biological information from groundfish samples. My sample number (unique ID) is a concatenation of a location code, a date stamp, and a sample number. The date stamp no longer works, only the year is displayed instead of month-day-year. The concatenation is accomplished using:
concat(substr(today(),7,5),substr(today(),10,8),substr(today(),2,4),' ',${vessel_samplenum})
only year is displayed instead of month-day-year.
2. What app or server are you using and on what device and operating system? Include version numbers.
Using kobotoolbox to host the form and windows 10 with internet explorer to enter data.
3. What you have you tried to fix the problem?
4. What steps can we take to reproduce the problem?
Use attached xls form to recreate form.
Seward_AWL.xlsx (42.9 KB)
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.