CommCare info dates

Hello,

Regarding the “info.closed_date” in case exports that looks something like
this: 2014-08-22T14:20:02Z:

Is this a date that can be recognized by Excel? If so, can you show me how?

Thanks.

Carol

Hey Carol,

I think if you check the box that says “Automatically convert dates for
Excel” it should change it to a format that excel recognizes.

Cory

··· On Thu, Jun 4, 2015 at 4:39 PM, Carol Holtzman wrote:

Hello,

Regarding the “info.closed_date” in case exports that looks something like
this: 2014-08-22T14:20:02Z:

Is this a date that can be recognized by Excel? If so, can you show me
how?

Thanks.

Carol


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.

Hi Cory,

Thanks for the response. I did check that box. But I don’t know how to
convert that into a simple date without the time.

Carol

··· On Thursday, June 4, 2015, Cory Zue wrote:

Hey Carol,

I think if you check the box that says “Automatically convert dates for
Excel” it should change it to a format that excel recognizes.

Cory

On Thu, Jun 4, 2015 at 4:39 PM, Carol Holtzman <carolholtzman@gmail.com <javascript:_e(%7B%7D,‘cvml’,‘carolholtzman@gmail.com’);>> wrote:

Hello,

Regarding the “info.closed_date” in case exports that looks something
like this: 2014-08-22T14:20:02Z:

Is this a date that can be recognized by Excel? If so, can you show me
how?

Thanks.

Carol


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
<javascript:_e(%7B%7D,‘cvml’,‘commcare-users%2Bunsubscribe@googlegroups.com’);>
.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/apEt_fZAefs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com
<javascript:_e(%7B%7D,‘cvml’,‘commcare-users%2Bunsubscribe@googlegroups.com’);>
.
For more options, visit https://groups.google.com/d/optout.

Hey Carol,

Ah - in excel you can likely use one of the steps mentioned here
http://excelsemipro.com/2012/09/extract-a-date-from-a-date-time-number-in-excel/.
(so DATE(YEAR(A2),MONTH(A2),DAY(A2)) if excel recognizes it, or LEFT(A2,
8) if it interprets it as text).

Cory

··· On Thu, Jun 4, 2015 at 5:57 PM, Carol Holtzman wrote:

Hi Cory,

Thanks for the response. I did check that box. But I don’t know how to
convert that into a simple date without the time.

Carol

On Thursday, June 4, 2015, Cory Zue czue@dimagi.com wrote:

Hey Carol,

I think if you check the box that says “Automatically convert dates for
Excel” it should change it to a format that excel recognizes.

Cory

On Thu, Jun 4, 2015 at 4:39 PM, Carol Holtzman carolholtzman@gmail.com wrote:

Hello,

Regarding the “info.closed_date” in case exports that looks something
like this: 2014-08-22T14:20:02Z:

Is this a date that can be recognized by Excel? If so, can you show me
how?

Thanks.

Carol


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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/apEt_fZAefs/unsubscribe.
To unsubscribe from this group and all its topics, 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.

Thanks Cory! This worked.

Carol