Thank you, Albert and Thomas! From: [email protected] [mailto:[email protected]] On Behalf Of Thomas J Hawley Sent: Wednesday, June 07, 2017 10:42 PM To: [email protected] Subject: Re: [RBASE-L] - difference between two dates
Keeping in mind that if you want the number of days between two dates, and deem the first and last days inclusive, you'll need to add 1 to the result. Tom Hawley On Wed, Jun 7, 2017 at 5:49 PM, Albert Berry <[email protected]<mailto:[email protected]>> wrote: R>SET VAR vDate2 DATE = 2017/06/06 R>SET VAR vDate1 DATE = 2017/06/01 R>SET VAR vDiff INTEGER = (.vDate2 - .vDate1) R>SHOW VAR vD% Variable = Value Type -------------------------------- ------------------------------ ------- vDir = -0- TEXT vDate2 = 2017/06/06 DATE vDate1 = 2017/06/01 DATE vDiff = 5 INTEGER On Jun 7, 2017, at 3:33 PM, Chaya Goldberg <[email protected]<mailto:[email protected]>> wrote: Hi All, I feel like this should be obvious, but can’t figure out how to do it. Is there a function that returns the difference between two dates in integer format, like datediff in SQL? Thanks in advance, Chaya -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
