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]> 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]>
> 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].
> 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.
>

-- 
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.

Reply via email to