Hello Community,
I've been developing a survey in connect for field data collection. We're deploying an underwater camera system where I need to record the time multiple times down to the second. That was a bit of a headache but found help figuring that out by creating a button. Now I've hit another wall where its displayed in 24 hr time and I can't figure out how to change it to 12 hr AM/PM time so that the data export can match our existing access database. Not the end of the world if I can't get it to work, just trying to avoid as much post processing as possible. Here's a sample of what I have on my spreadsheet, any help is appreciated!:
| type | name | label | calculation | relevant |
| select_one update_drop | refresh_drop | Drop Time: | | |
| calculate | drop_time | Drop Time | once(format-date(now(), '%n/%e/%Y %H:%M:%S')) | ${refresh_drop}="record" |
| note | camera_drop_time | ${drop_time} | | |
