Application Status Report Date/Time format

When the Application Status report is exported from CommCareHQ the
date/time format of the Last Submission and Last Sync columns are in a
number format I don’t recognize. Is this documented somewhere? Is it an
epoch or some interval between 2 dates?

Thanks in advance.

For anyone curious it is an ordinal date (proleptic Gregorian ordinal).
Basically the number of days since December 31st, 0000. So January 1st,
0001 would be represented as the number 1.

It seems like we are losing the time information in the exported report
then.

··· On Friday, July 24, 2015 at 1:55:20 PM UTC-4, Duncan Scott Spencer wrote:

When the Application Status report is exported from CommCareHQ the
date/time format of the Last Submission and Last Sync columns are in a
number format I don’t recognize. Is this documented somewhere? Is it an
epoch or some interval between 2 dates?

Thanks in advance.

Hey,

This sounds like a bug. I’ll log it in our issue tracker and see if we can
change the dates to something more consumable.

Cory

··· On Fri, Jul 24, 2015 at 10:05 PM, Duncan Scott Spencer wrote:

For anyone curious it is an ordinal date (proleptic Gregorian ordinal).
Basically the number of days since December 31st, 0000. So January 1st,
0001 would be represented as the number 1.

It seems like we are losing the time information in the exported report
then.

On Friday, July 24, 2015 at 1:55:20 PM UTC-4, Duncan Scott Spencer wrote:

When the Application Status report is exported from CommCareHQ the
date/time format of the Last Submission and Last Sync columns are in a
number format I don’t recognize. Is this documented somewhere? Is it an
epoch or some interval between 2 dates?

Thanks in advance.


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

Hey Duncan,

We’ve been able to fix this. Dates should now be exporting in a more
readable format.

thanks,
Cory

··· On Sun, Jul 26, 2015 at 9:20 AM, Cory Zue wrote:

Hey,

This sounds like a bug. I’ll log it in our issue tracker and see if we can
change the dates to something more consumable.

Cory

On Fri, Jul 24, 2015 at 10:05 PM, Duncan Scott Spencer <dsspence@gmail.com wrote:

For anyone curious it is an ordinal date (proleptic Gregorian ordinal).
Basically the number of days since December 31st, 0000. So January 1st,
0001 would be represented as the number 1.

It seems like we are losing the time information in the exported report
then.

On Friday, July 24, 2015 at 1:55:20 PM UTC-4, Duncan Scott Spencer wrote:

When the Application Status report is exported from CommCareHQ the
date/time format of the Last Submission and Last Sync columns are in a
number format I don’t recognize. Is this documented somewhere? Is it an
epoch or some interval between 2 dates?

Thanks in advance.


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

Thanks Cory we appreciate it.

··· On Tuesday, July 28, 2015 at 3:54:23 AM UTC-4, Cory Zue wrote: > > Hey Duncan, > > We've been able to fix this. Dates should now be exporting in a more > readable format. > > thanks, > Cory > > On Sun, Jul 26, 2015 at 9:20 AM, Cory Zue <cz...@dimagi.com > wrote: > >> Hey, >> >> This sounds like a bug. I'll log it in our issue tracker and see if we >> can change the dates to something more consumable. >> >> Cory >> >> On Fri, Jul 24, 2015 at 10:05 PM, Duncan Scott Spencer <dssp...@gmail.com > wrote: >> >>> For anyone curious it is an ordinal date (proleptic Gregorian ordinal). >>> Basically the number of days since December 31st, 0000. So January 1st, >>> 0001 would be represented as the number 1. >>> >>> It seems like we are losing the time information in the exported report >>> then. >>> >>> On Friday, July 24, 2015 at 1:55:20 PM UTC-4, Duncan Scott Spencer wrote: >>> >>>> When the Application Status report is exported from CommCareHQ the >>>> date/time format of the Last Submission and Last Sync columns are in a >>>> number format I don't recognize. Is this documented somewhere? Is it an >>>> epoch or some interval between 2 dates? >>>> >>>> Thanks in advance. >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "commcare-users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to commcare-user...@googlegroups.com . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >