What is submission_time that is seen in the xls dataset?


We are getting a column in addition to our variables labeled as ‘_submission_time’, which contains date and time for each case. Our data is being collected from multiple remote sites using KoboCollect. We are not able to relate it with our work, kindly explain what does it mean and how can it be useful to us?

Thanks in advance

Hi @peeyush,

This is a sample of what you see in your xls dataset that you download from KoBoToolbox:

As seen in the image above, it is a summary of the international standard date and time notation following the International Standard ISO 8601 notation. The front part before the T is the date while the latter part is the time when the filled up form was recorded to the server.

According to the International Standard ISO 8601 notation, if a date and a time are displayed on the same line, then the date should be written in front of the time. If a date and a time value are stored together in a single data field, they should be separated by a latin capital letter T.

Source: https://www.cl.cam.ac.uk/~mgk25/iso-time.html

Thank you @Kal_Lam!

It now makes sense, what I want to know more is as we are collecting data through KoboCollect in offline-online mode, what if an enumerator fails to get internet connectivity on the same day (say 25 Sep 2019) of submission and gets it on another day (that is 26 Sep 2019), then which date the submission time column will show?

Best wishes

Hi @peeyush,

I would generally use the date question type to capture the date of the data collection instead of using the submission_time meta data generated by KoBoToolbox. Instead i would simply use the submission_time meta data to keep record of when the data was submitted to the server.