Re: SQR Datediff?

[Mike Olson <msolson@FASTENAL.COM>]

Sounds like you didn't declare your variables as dates.
declare-variable
  date $asoftoday
  date $effdt
end-declare

> -----Original Message-----
> From: Buchanan, Timothy [SMTP:buchanan@BIPERF.COM]
> Sent: Tuesday, August 24, 1999 2:37 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      SQR Datediff?
>
> 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