Statalist The Stata Listserver

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

Re: st: dates

From   Joseph Coveney <>
To   Statalist <>
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:

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