Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query (date more than 2 years old)
Message
 
To
31/08/2005 13:53:59
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Microsoft Office
Category:
Access
Title:
Re: Query (date more than 2 years old)
Miscellaneous
Thread ID:
01045593
Message ID:
01045619
Views:
28
This message has been marked as the solution to the initial question of the thread.
... WHERE (year(table_name.date_field))< year(now())-2

>Kind of a simple question, but I have forgotten how to do it.
>
>I have a table with a date field, and I want to query to see the records 2 years older than the date I run the query. Any advice?
>
>TIA!
>
>MAC
Previous
Reply
Map
View

Click here to load this message in the networking platform