Re: DateDiff()
select * from accounts
where (extend(referral_date, year to day) - datetime( '2003-02-06' ) year today) = interval (60) day(4) to day;
Art S. Kagel
> How do I do a DateDiff function like in MsSQL? I have tried the following:
>
> select * from accounts where (extend(referral_date, year to day) -> extend('02/06/2003', year to day)) = 60
>
> but it is returning an error "Non-numeric character in dtetime or interval"
>
>
>
> Robert Phillips
> Systems Analyst
> Chamberlin Edmonds and Associates (www.ce-a.com)
> 404-634-5196 x1261