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