Opened_date query

Hello

I have never investigated the opened_date property before.

But I am doing it now and find many cases with an opened_date of 2016-09-01
00:00:00. I have exported all our cases and this is also the oldest
open_date in the exported dataset.

Why is this the oldest date and why are they so many cases with this same
date?

We did set-up our system initially with an import of the data we had at the
time (using the case import function) but that was in 2014 (not 2016). The
default date range I’m given when doing a case export is: 2014-01-16 to
<today’s date>. Where is the system getting the date of 2014-01-16 from?
I’d assumed it was the date the first case was opened.

Help!

Regards

Simon
1/12/17

I’m keen to get a response to this!

As further evidence of the problem, I attach a screen shot of a part of the
data. You will see that the ‘system property’ opened_date is set to 1/9/16
but other dates entered by the user are before this date eg the date the
retailer (case) was marked as closed (closed_date). How can this happen if
the users are entering the dates correctly which I am sure they are.
Obviously a case cannot be closed before it is opened…

A prompt response would be appreciated.

Many thanks

Simon
4/12/17

Microsoft ExcelScreenSnapz079.pdf (17.6 KB)

··· On Friday, December 1, 2017 at 10:01:56 PM UTC, Simon Berry wrote: > > Hello > > I have never investigated the opened_date property before. > > But I am doing it now and find many cases with an opened_date of > 2016-09-01 00:00:00. I have exported all our cases and this is also the > oldest open_date in the exported dataset. > > Why is this the oldest date and why are they so many cases with this same > date? > > We did set-up our system initially with an import of the data we had at > the time (using the case import function) but that was in 2014 (not 2016). > The default date range I'm given when doing a case export is: 2014-01-16 to > . Where is the system getting the date of 2014-01-16 from? > I'd assumed it was the date the first case was opened. > > Help! > > Regards > > Simon > 1/12/17 > > >

Hi Simon

We’d need to look at specific cases in order to determine what’s going on.

Please could you create a support ticket with some example cases so that we
can look into it further.

Thanks

Simon Kelly
Director of Server Engineer | Dimagi

··· On 4 December 2017 at 12:44, Simon Berry wrote:

I’m keen to get a response to this!

As further evidence of the problem, I attach a screen shot of a part of
the data. You will see that the ‘system property’ opened_date is set to
1/9/16 but other dates entered by the user are before this date eg the date
the retailer (case) was marked as closed (closed_date). How can this happen
if the users are entering the dates correctly which I am sure they are.
Obviously a case cannot be closed before it is opened…

A prompt response would be appreciated.

Many thanks

Simon
4/12/17

On Friday, December 1, 2017 at 10:01:56 PM UTC, Simon Berry wrote:

Hello

I have never investigated the opened_date property before.

But I am doing it now and find many cases with an opened_date of
2016-09-01 00:00:00. I have exported all our cases and this is also the
oldest open_date in the exported dataset.

Why is this the oldest date and why are they so many cases with this same
date?

We did set-up our system initially with an import of the data we had at
the time (using the case import function) but that was in 2014 (not 2016).
The default date range I’m given when doing a case export is: 2014-01-16 to
<today’s date>. Where is the system getting the date of 2014-01-16 from?
I’d assumed it was the date the first case was opened.

Help!

Regards

Simon
1/12/17


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.