Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: RE: RE: RE: RE: RE: RE: dates


From   "Nick Cox" <[email protected]>
To   <[email protected]>
Subject   st: RE: RE: RE: RE: RE: RE: RE: dates
Date   Tue, 1 Apr 2003 19:04:12 +0100

Vania Gerova
> 
> > Excuse my ignorance and if not wasting your time, could you 
> > please tell me
> > more about 21914, I am just guessing at the moment.
> 
> As pointed out previously, 33824 
> is (almost) 8 August 1992 expressed as days after 
> 1 January 1900: 
> 
> . di mdy(8,8,1992) - mdy(1,1,1900) 
> 33822
> 
> In any case, Stata uses an origin 
> of 1 January 1960, so to adjust 
> your dates to Stata's origin 
> I derived the difference between 
> origins: 
> 
> . di mdy(1,1,1960) - mdy(1,1,1900) 
> 21914
> 

The story on Excel and 29 Feb 1900 is at 

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q181370

Actually, if Vania knows that 8 August 1992 == 33824, 
the correct constant would appear to be 21916. 

. di %dd_m_Cy 33824 - 21916
 8 Aug 1992

That's my bug. 

Nick 
[email protected] 
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index