This is not 100% the same but something to work with. I have a view on a log
table that shows the log for the last 7 dayes like this

CREATE VIEW "7dayswebaccess"(ID,IP,TS,SESSION,KUNDE,CONTEXT,QSTRING)
AS
select * from webaccess where ts > cast('now' AS Date) - 7

Looks like You should be able to simply say CloseDate < cast('now' AS
Date) - 356*2

Jan

----- Original Message -----
From: "Durrani" <durrani@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, February 18, 2003 10:03 AM
Subject: [ib-support] Date


> Hi There
>
> How to find out difference between two dates.
>
> My requirement is...
>
> A table(myTbl) has a date field(CloseDate).
>
> I want to select all columns from myTbl where CloseDate is more than 2
years
> old.
>
> Thanks in advance.
>
> Regards
> Durrani, Mohamed A.
> Bangalore. India.
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>