Changing time format from 12 hr to 24 hr

[mezbaker]

We tried using the solution with the military time formatting discussion from 2019 but it did not work. It still displays in 12 hour am/pm format. Perhaps Kobo forms have changed since 2019?

Any help would be deeply appreciated.

[mezbaker]

Here is the same image but with column names.

[Xiphware]

I’m not exactly sure what the issue is you are seeing, but try playing around with this form. It’ll consume a time and then display it in 24-hr format. Note the need to turn the input time into a dateTime, in order for the format-date-time() function to work correctly.

aWqsYYQyQg47pcGB6VxniL.xlsx (5.8 KB)

[mezbaker]

Appreciate your attempts to help us. This is still not working. Here is a pic of the error message and of our xls file.

[mezbaker]

[mezbaker]

Also, we get the same error on the same line (the first “calculate” row is “row 18” even if we put in dateTime as suggested above.

[mezbaker]

the wildest thing is that we are running a very similar survey in a different region and for some reason the 24h format works there. we’ve tried copying and pasting it in EXACTLY as is, and it still produces an error. This is working for some wild reason in our other region:

[Xiphware]

Can you please share your entire form; not a screenshot. It looks like you have calculate lines but nothing in an associated calculation column. This would result in a ‘Missing calculation’ error.

[whereas your “${collect} = ...” would appear to be in a relevant column, but again its impossible to tell without seeing the entire form]

[mezbaker]

Ah ha!!! You fixed it. The column name was “appearance” and not “calculation” thus it was not performing the calculation!! Sheesh! Thank you!!