Exporting cases - format dates for Excel

Users
1

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

2

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 > > > > >
3

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.

4

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.