Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: dates


From   Joseph Coveney <jcoveney@bigplanet.com>
To   Statalist <statalist@hsphsun2.harvard.edu>
Subject   Re: st: dates
Date   Mon, 21 May 2007 09:30:32 +0900

Ali Khashan wrote:

I want to format a date variable.
I tried these codes:
gen nDate=date(sDate, "dm19y")
format nDate %dD_m_CY

However it did not work and then I realised that the dates included time
"03/02/2005 00:00".

Is there a stata code which can deal with this date?

--------------------------------------------------------------------------------

Yes. You can isolate the date part using the official Stata
function -substr()-, that is,

generate int nDate = date(substr(sDate, 1, 10), "mdy")

But there is a user-written program by Nick Cox that handles these
situations more generally.  It's -ntimeofday-, and can be downloaded from
_The Stata Journal_ website.  Type -findit ntimeofday-.

Joseph Coveney


*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index