Re: SQR Datediff?

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

oh....my....god.....

It was just that simple!

Sometimes I hate SQR......

Travis, the next time you are in Minneapolis, the beer is on me!!

Timm


> -----Original Message-----
> From: Ormond, Travis R [SMTP:Travis.Ormond@West.Boeing.com]
> Sent: Tuesday, August 24, 1999 2:50 PM
> To:   Buchanan, Timothy
> Subject:      RE: SQR Datediff?
>
> Timm,
>
> I've seen this error message before.  Try explicitly declaring the date
> variables that will be used in the function.  Apparently, SQR is not
> always
> "smart" enough to know what type of "$" variable is being used (date or
> string).
>
> Good luck.
> Travis
>
>
> > 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
> >