Various date fields in xform submission

Hi all,

I’m trying to find a field in the data export that represents the time on
the server that the form was submitted. I know these two:

form.meta.timeStart - datetime on the phone when the form was started
form.meta.timeEnd - datetime on the phone when the form was completed

These are the other datetime fields in the export. Can you describe the
other 3 fields and specify whether they are phone or server time?

date_header
form.case.date_modified
openrosa_headers.HTTP_DATE

Thanks!
Jon

Hi all,

I’m trying to find a field in the data export that represents the time on
the server that the form was submitted.

Actually what you’re looking for is “received_on”.

I know these two:

form.meta.timeStart - datetime on the phone when the form was started
form.meta.timeEnd - datetime on the phone when the form was completed

These are the other datetime fields in the export. Can you describe the
other 3 fields and specify whether they are phone or server time?

date_header

openrosa_headers.HTTP_DATE

These two should be equivalent, and are the time the phone thought it was
when it submitted (not filled in) the form.

form.case.date_modified

This is typically the same as the date the form was filled in (not sure if
it’s timeStart/timeEnd or something in between).

Cory

··· On Wed, Jan 11, 2012 at 10:12 AM, Jonathan Payne wrote:

Awesome. Thanks!

form.case.date_modified is also the phone time, then?

··· On Jan 11, 2012, at 10:34 AM, Cory Zue wrote:

On Wed, Jan 11, 2012 at 10:12 AM, Jonathan Payne paynejd@gmail.com wrote:
Hi all,

I’m trying to find a field in the data export that represents the time on the server that the form was submitted.

Actually what you’re looking for is “received_on”.

I know these two:

form.meta.timeStart - datetime on the phone when the form was started
form.meta.timeEnd - datetime on the phone when the form was completed

These are the other datetime fields in the export. Can you describe the other 3 fields and specify whether they are phone or server time?

date_header
openrosa_headers.HTTP_DATE

These two should be equivalent, and are the time the phone thought it was when it submitted (not filled in) the form.

form.case.date_modified

This is typically the same as the date the form was filled in (not sure if it’s timeStart/timeEnd or something in between).

Cory

form.case.date_modified is also the phone time, then?

Correct.

··· On Wed, Jan 11, 2012 at 10:42 AM, Jonathan Payne wrote:

On Jan 11, 2012, at 10:34 AM, Cory Zue wrote:

On Wed, Jan 11, 2012 at 10:12 AM, Jonathan Payne paynejd@gmail.comwrote:

Hi all,

I’m trying to find a field in the data export that represents the time on
the server that the form was submitted.

Actually what you’re looking for is “received_on”.

I know these two:

form.meta.timeStart - datetime on the phone when the form was started
form.meta.timeEnd - datetime on the phone when the form was completed

These are the other datetime fields in the export. Can you describe the
other 3 fields and specify whether they are phone or server time?

date_header

openrosa_headers.HTTP_DATE

These two should be equivalent, and are the time the phone thought it was
when it submitted (not filled in) the form.

form.case.date_modified

This is typically the same as the date the form was filled in (not sure if
it’s timeStart/timeEnd or something in between).

Cory