Change in time/date stamp?

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.

I've resolved this issue. Not too sure what changed but updating the calculation to
concat(substr(today(),5,7),substr(today(),8,10),substr(today(),2,4),' ',${vessel_samplenum})
fixed the issue. Now the unique ID is displayed as MMDDYY vessel number sample number

1 Like