Field and server timezones

Hi everyone,

While exporting forms I’ve noticed that server.received_on is sometimes earlier
than info.completed time :

For example :
server.received_on : 2014-07-25 10:20:13
info.completed_time : 2014-07-25 16:50:05

I assume that this is caused because of the field workers are not in the same time
zone as the server.

Is there a way to query the timezone of the server ? Is it stored as a value in the
form ?

Many thanks,

··· -- Charles Flèche mHealth Advisor Télécoms Sans Frontières http://www.tsfi.org Première Urgence - Aide Médicale Internationale http://www.pu-ami.org

The server time will always be UTC. The completed time will always be the
time the phone gave but with the timezone stripped (not converted to UTC,
just stripped). We realize this is a huge shortcoming and applies to all
self-reported phone dates, and it is a known problem that is in our backlog
to fix.

I realize that this is a disappointing answer. For the majority of forms,
you will likely have prior knowledge of their timezone, and you can factor
that in during your analysis for the time being. Our sincerest apologies
for this unintuitive aspect of our system; I hope in the short term this
workaround meets your needs.

Best,
Danny

··· On Thu, Feb 5, 2015 at 11:17 AM, Charles Flèche wrote:

Hi everyone,

While exporting forms I’ve noticed that server.received_on is sometimes
earlier than info.completed time :

For example :

server.received_on : 2014-07-25 10:20:13

info.completed_time : 2014-07-25 16:50:05

I assume that this is caused because of the field workers are not in the
same time zone as the server.

Is there a way to query the timezone of the server ? Is it stored as a
value in the form ?

Many thanks,

Charles Flèche

mHealth Advisor

Télécoms Sans Frontières http://www.tsfi.org

Première Urgence - Aide Médicale Internationale http://www.pu-ami.org


You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

That’s fine : my field workers are working within the same timezone, the
server timezone is always UTC, I should be able to convert dates by myself.

Many thanks,

··· On Thursday 05 February 2015 13:35:30 Danny Roberts wrote: > The server time will always be UTC. The completed time will always be the


Charles Flèche
mHealth Advisor
Télécoms Sans Frontières http://www.tsfi.org
Première Urgence - Aide Médicale Internationale http://www.pu-ami.org