SQR Datediff?

["Buchanan, Timothy" <buchanan@BIPERF.COM>]

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