1. What is the issue? Please be detailed.
Pull datatime field from csv works on Enketo but not on ODK Collect, the idea is generate a datetime field (named study_date) in an initial form submit, download the data in csv and then use this information in other form to find the difference in minutes between the current date and the study date. Attached formats work fine in Enketo, but not in ODK Collect.
ODK Collect: v2022.1.2, ODK Central v1.4.2
2. What steps can we take to reproduce this issue?
2.1. Upload the form dateTime_initial_data.xls to ODK Central, submit any data.
2.2. Download the data in csv as data.csv no group names (example in data.csv).
2.3. Upload the form dateTime_receiver_test_functional_Enketo.xls to ODK Central and in media files upload data.csv.
2.4. Try submit data in form dateTime_receiver_test_functional_Enketo, calling ID numbers 80131 and 1022 (previous in data.csv), in Enketo and then in ODK Collect . In Enketo it works well, in ODK Collect appears the error that I attach in the image error_in_format_datetime_ODKCollect.jpg next to ID insertion (ID related with csv data).
3. What have you tried to fix the issue?
I have tried to format the datetime as shown in the file dateTime_receiver_try_ODKCollect_test1.1.xls that once I tried to upload it shows me the error that I attach in the image error_try_fix.
dateTime_receiver_try_ODKCollect_test1.1.xlsx (13.4 KB)
I appreciate your help so that it can work in ODK Collect as it works in Enketo