# startTime greater than endTime

**URL:** <https://forum.getodk.org/t/starttime-greater-than-endtime/18586>\
**Category:** Support\
**Created:** [March 15, 2019, 5:38am UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586 "2019-03-15T05:38:32Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![ferd](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ferd/32/4925_2.png) [@ferd](https://forum.getodk.org/u/ferd)\
**Post date:** [March 15, 2019, 5:38am UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/1 "2019-03-15T05:38:32Z")

</div>

Hello,

I have noticed some funny trend in my dates.  
Some instances in my data have startTime greater than endTime.  
This data is collected using ODK collect.

---

<div class="post-metadata">

**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\
**Post date:** [March 15, 2019, 3:15pm UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/2 "2019-03-15T15:15:09Z")

</div>

Hi @ferd  
Are you able to reproduce the issue?  
Is the issue visible just on one device?

---

<div class="post-metadata">

**Author:** ![ferd](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ferd/32/4925_2.png) [@ferd](https://forum.getodk.org/u/ferd)\
**Post date:** [March 16, 2019, 6:56am UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/3 "2019-03-16T06:56:14Z")

</div>

Hi @Grzesiek2010,  
This happens in several devices.

 ![image](https://getodk.b-cdn.net/uploads/default/original/2X/4/443f728ceb73fb498ef42938c2e2f5094191855f.png)  
I have attached a screenshot of some of the observations. You will notice from the bottom right of the screenshot that there are over 1600 observations with the problem spanning across several years.

This is just one of the datasets I work.

---

<div class="post-metadata">

**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\
**Post date:** [March 16, 2019, 7:49pm UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/4 "2019-03-16T19:49:59Z")

</div>

Could you attach that form?

---

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [March 17, 2019, 6:10pm UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/5 "2019-03-17T18:10:22Z")

</div>

Also, what versions of Collect are you using? And what versions of the server? And how exactly are you generating this CSV?

---

<div class="post-metadata">

**Author:** ![ferd](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ferd/32/4925_2.png) [@ferd](https://forum.getodk.org/u/ferd)\
**Post date:** [March 19, 2019, 7:17am UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/6 "2019-03-19T07:17:38Z")

</div>

Hi @Grzesiek2010 and @yanokwa,

The aggregate server version we are using is **1.5.0** which we upgraded this year from **1.4.13**. Yet we still have the some instances of this in 2019 (just that I could not screenshot all)

Most of our data collectors are currently using collect **v1.17 and 1.18.2** Its not very easy to explain the collect version because there have been updates and as you might see this issues spans over a few years.

The csv was downloaded using odk briefcase **v1.11.2**.  
Please find a extract of how we collect the metadata.  
[Community\_survey.xlsx](https://getodk.b-cdn.net/uploads/default/original/2X/0/07844262bf4d49075921a6bff107e2a12c4f831e.xlsx) (11.6 KB)

---

<div class="post-metadata">

**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\
**Post date:** [March 19, 2019, 11:55am UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/7 "2019-03-19T11:55:40Z")

</div>

You attached a screenshot from you exported csv file but could you check values in Aggregate? Are those values the same there or they changed after exporting?

---

<div class="post-metadata">

**Author:** ![1119](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/1119/32/6042_2.png) [@1119](https://forum.getodk.org/u/1119)\
**Post date:** [March 19, 2019, 1:11pm UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/8 "2019-03-19T13:11:55Z")

</div>

It might be system date/time setting of the device.

---

<div class="post-metadata">

**Author:** ![ferd](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ferd/32/4925_2.png) [@ferd](https://forum.getodk.org/u/ferd)\
**Post date:** [March 19, 2019, 3:21pm UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/9 "2019-03-19T15:21:45Z")

</div>

Please see a screenshot from the server ( This is from one of the users) indicating the wrong time

 ![image](https://getodk.b-cdn.net/uploads/default/original/2X/9/9dd254d2fe6b72c96295828ab47b77ddf9441f83.png)

Notice the same user has a correct time on the same day

 ![image](https://getodk.b-cdn.net/uploads/default/original/2X/2/23ed0a283a04e85bdf7585b114e09ce3508b0492.png)

---

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [March 21, 2019, 4:44am UTC](https://forum.getodk.org/t/starttime-greater-than-endtime/18586/10 "2019-03-21T04:44:34Z")

</div>

Well this is a peculiar problem! Would you happen to have the /odk folder with one or two of the bad submissions?

My guess is that the devices are somehow getting their times changed. Maybe there's a bug on the operating system of device? Or the devices are set to network time and network time is wrong? Or maybe someone is changing the time zone?
