Submission Time/Date error

Hello everyone !

Description

While still doing training to colleagues with Kobotoolbox, we discovered that the submissions dates appearing in the “Summary” windows were 1 day earlier than the actual dates of submissions.

See below for exempale : I did two trainings, one on May 20th and another one on June 3rd, where my colleagues sent (live) their submission to a questionnaire.
For some reasons I can’t explain (see screenshot below) the report in the “summary” windows show that a first set of submissons was received on May 19th (1 day earlier) and a second set of submissions was received on June 2nd (1 day earlier again).

image

Expected behavior

I would expect the submissions sent on May 20th to be reported as received May 20th (instead of May 19th) as well as the submission sent on June 3rd (instead of June 2nd)

Actual behavior

The report in the “summary” windows show that a first set of submissons was received on May 19th (1 day earlier) and a second set of submissions was received on June 2nd (1 day earlier again).

Additional details

I wonder if this is due to some Time zone settings problem between Kobo/ODK collect / smartphone settings ?
I barely believe it could be this : all the 17 submissions produced the same bug and I’m almost sure everyone had at least the good time and date on its smartphone.

Or a mysterious French/English version ?

I spent quite some time if there was any way to manipulate time-zone settings with ODK or Kobotoolboox and didn’t find any settings for this.

This is why I call for help to the community

Thank in advance for any advice to fix this problem.

Hi @calasj_eva,

Would you mind sharing the submitted data in tabular format too. That would help visualize the problem further clearly. I just made a check on kobotoolbox.org (HHI server) and see that they are working absolutely fine form my end. Please see the image below:

Hi @Kal_Lam,

Here is the tabular form of submissions with the 2 sets of dates of submissions (June 3rd and May 20 th).

image

And below is the report in the summary window : ti show that submissions were on June 2nd and May 19th… (???).

image

What do you think ?

By the way, I don’t understand why it gives me the date of today: “june 11th” below:

image

Difficult to understand what it means.

Thank you for any advise.

Hi
Just joining in on this, Normally the time stamp on the servers is dependent on the server times and not your local country time. As such the server time stamps would differ by the same margin to the local time zone. One way is to potentially add a manual time on your form and then compare that with the server time. Given this known difference, I strongly recommend that any time based assessments should be done using the local time put in the form and not the server time.

Regards
Stephane

1 Like

Thank you very much !
That explains everything !

:ok_hand: