Neil,
I did open the stata file.
the stata file has the number 500 in the cell. The format forces the
500 to appear as Sep 2001 when viewed using edit or list. This when
outsheeted becomes 9/1/2008.
Thank you,
Ashim.
On Wed, Dec 10, 2008 at 5:25 PM, Neil Shephard <[email protected]> wrote:
> Ashim Kapoor wrote:
>> Hello Neil,
>>
>> Thank you for your reply.
>>
>> For example the number 586 which under the format %tm mean November
>> 2008 in Stata becomes 11/8/2008 in excel, where does excel choose this
>> 8th day from ?
>>
>> But more than this some dates get even the month wrong like for
>> example the number 500 which is september 2001, becomes 9/1/2008. The
>> year changes!!!
>>
>>
> Are the '586' and the '500' the format of the dates in the file you are
> -outsheet-ing to or is this from within Stata?
>
> Open the text file and look at how these have been -outsheet-ed and this
> may provide some insight as to why things are happening strangely.
>> Does this seem like a simple problem to fix ? Anything like this have you seen?
>>
> I'm not very familiar with Excel, but I suspect you are assuming that
> Stata and Excel are using the same (arbitrary) reference date for
> calculating elapsed dates which is not the case. In Stata elapsed dates
> are counted from 01jan1960 whilst in Excel 2007 they are counted from
> 00January1900.
>
> The solution is likely to be to -outsheet- with labels and converting
> the string dates to the correct format in Excel.
>
> Neil
>
> --
> "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." - Albert Einstein
>
>
> ***********************************************************************
> This message may contain confidential and privileged information.
> If you are not the intended recipient you should not disclose, copy
> or distribute information in this e-mail or take any action in reliance
> on its contents. To do so is strictly prohibited and may be unlawful.
> Please inform the sender that this message has gone astray before
> deleting it. Thank you.
>
> 2008 marks the 60th anniversary of the NHS. It's an opportunity to pay
> tribute to the NHS staff and volunteers who help shape the service, and
> celebrate their achievements.
>
> If you work for the NHS and would like an NHSmail email account, go
> to: www.connectingforhealth.nhs.uk/nhsmail
> ***********************************************************************
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
