[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: months_between.

Try using the  DATEDIFF function

Example:   DATEDIFF($CURRENT DATE, &EFFDT,'MONTH') <= #No_of_Month_Input

Word of caution:  make sure that the 2 dates being compared are declared as date
variables.
Hope this helps






Nhat-Ha Duong <nhat-ha.p.duong@BELLATLANTIC.COM> on 11/02/99 04:38:26 PM

Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Rick Creel/IT/Aon Consulting)

Subject:  months_between.




Is there a similar function to MONTHS_BETWEEN in SQR?  Here is what I tried to
do:

select
...
EFFDT,
...
from
....
where
...
and MONTHS_BETWEENS(CURRENT DATE, &EFFDT) <= #No_of_Month_Input

Thanks,
Nhat-Ha