Re: st: Time between 2 dates

[Laurie Molina <molinalaurie@gmail.com>]

Thank you both, that was exactly what i needed!
Regards,
LM

On Wed, Jan 26, 2011 at 11:42 AM, Nick Cox <n.j.cox@durham.ac.uk> wrote:
> Notice that you can omit the intermediate variables if you don't want them.
>
> gen long daysbetween = date(enddate, "YMD") - date(startdate, "YMD")
>
> As David explained, this is based on the assumption that you have string variables. If you have numeric variables with date formats, then the time between two dates is just the difference.
>
> Nick
> n.j.cox@durham.ac.uk
>
> David Kantor
>
> At 12:06 PM 1/26/2011, Laurie wrote:
>>Hi all, i would like to calculate the time between 2 dates in a data set.
>>
>>I have start date like: 2010/08/02 meaning august 2nd 2010
>>and end date like: 2011/02/08 meaming february 2nd 2011.
>>
>>I would like to know how many days are between the start date and
>>the end date.
>>[...]
>
> Presumably these values such as 2010/08/02 are of string types. First
> convert them to Stata dates. Assuming the variables are named
> startdate and enddate:
> gen long startdate_n = date(startdate, "YMD")
> gen long enddate_n = date(enddate, "YMD")
>
> (The new variables are named with _n to signify "numeric", but of
> course, the names are arbitrary.)
> You may also want...
> format startdate_n enddate_n %d
> (or any of several date formats) but that is optional.
> Then just take the difference:
> gen long daysbetween = enddate_n -startdate_n
>
>
> *
> *   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/