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/
