Re: SQR Datediff?

[Sam Spritzer <SSpritzer@GW.CTG.COM>]

I m tossing this in the wind but what version of SQR are you on?  Datediff is new for ver. 4.
Sam

<<< "Buchanan, Timothy" <buchanan@BIPERF.COM>  8/24  3:36p >>>
Anyone get datediff function to work in SQR in an Oracle environment? I am
trying to find the difference in days between 2 dates using the following
code in a SQL statement:

        LET #dif = DATEDIFF($asoftoday, $effdt, 'DAY')

I get the error: Function or operator 'datediff' requires date argument.

Using debug, I can see that $asoftoday and $effdt are equal to the
following:

ASOFTODAY = 24-AUG-1999
EFFDATE = 01-JUL-1998

Hmm..sure look like dates to me. I even tried to use STRTODATE on each
variable, but it still gives me the same error. Any help?? Thanks.

Timm