Exporting cases - format dates for Excel

Hi

I’m exporting cases to Excel and I’ve checked the box ‘Automatically
convert dates and links for Excel’

However, in my export the dates appear like this: 2017-03-04 and they don’t
respond to date calculation functions. How can I fix this?

Many thanks

Simon
23/3/17

I posted this query in March (see below) and didn’t get a reply so I have
set up my dashboards to convert the ‘text dates’ from CommCare into Excel
dates. So far, so good.

However, all of a sudden, CommCare is exporting Excel dates so none of my
dashboards work. But that’s fine I thought, I’ll just UNcheck
’Automatically convert dates and links for Excel’ and everything will be
fine. But when I do this CommCare continues to convert the CommCare data to
Excel dates.

Help!

Simon

··· On Thursday, March 23, 2017 at 1:22:00 PM UTC, Simon Berry wrote: > > Hi > > I'm exporting cases to Excel and I've checked the box 'Automatically > convert dates and links for Excel' > > However, in my export the dates appear like this: 2017-03-04 and they > don't respond to date calculation functions. How can I fix this? > > Many thanks > > Simon > 23/3/17 > > > > >

Hi Simon

Sorry to hear about the difficulty. Please could you report an issue
through CommCare and we’ll look into the issue. We did recently migrate our
exports to a new backend infrastructure which would explain what you
observed but unchecking the ‘Automatically convert dates and links for
Excel’ option should still work.

Thanks

Simon Kelly
Director of Server Engineer | Dimagi

··· On 5 September 2017 at 17:57, Simon Berry wrote:

I posted this query in March (see below) and didn’t get a reply so I have
set up my dashboards to convert the ‘text dates’ from CommCare into Excel
dates. So far, so good.

However, all of a sudden, CommCare is exporting Excel dates so none of my
dashboards work. But that’s fine I thought, I’ll just UNcheck
’Automatically convert dates and links for Excel’ and everything will be
fine. But when I do this CommCare continues to convert the CommCare data to
Excel dates.

Help!

Simon

On Thursday, March 23, 2017 at 1:22:00 PM UTC, Simon Berry wrote:

Hi

I’m exporting cases to Excel and I’ve checked the box ‘Automatically
convert dates and links for Excel’

However, in my export the dates appear like this: 2017-03-04 and they
don’t respond to date calculation functions. How can I fix this?

Many thanks

Simon
23/3/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.

Thanks Simon. I’ve submitted a bug report and waiting for a response.

With best wishes

Simon
11/9/17

··· On 11 September 2017 at 11:58, Simon Kelly wrote:

Hi Simon

Sorry to hear about the difficulty. Please could you report an issue
through CommCare and we’ll look into the issue. We did recently migrate our
exports to a new backend infrastructure which would explain what you
observed but unchecking the ‘Automatically convert dates and links for
Excel’ option should still work.

Thanks

Simon Kelly
Director of Server Engineer | Dimagi

On 5 September 2017 at 17:57, Simon Berry simon@colalife.org wrote:

I posted this query in March (see below) and didn’t get a reply so I have
set up my dashboards to convert the ‘text dates’ from CommCare into Excel
dates. So far, so good.

However, all of a sudden, CommCare is exporting Excel dates so none of my
dashboards work. But that’s fine I thought, I’ll just UNcheck
’Automatically convert dates and links for Excel’ and everything will be
fine. But when I do this CommCare continues to convert the CommCare data to
Excel dates.

Help!

Simon

On Thursday, March 23, 2017 at 1:22:00 PM UTC, Simon Berry wrote:

Hi

I’m exporting cases to Excel and I’ve checked the box ‘Automatically
convert dates and links for Excel’

However, in my export the dates appear like this: 2017-03-04 and they
don’t respond to date calculation functions. How can I fix this?

Many thanks

Simon
23/3/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.


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.