I have a table with a datefield called LOADDATE.

I want to find all the records with LOADDATE within one year from today's date (in the past)....

What would be a quick and simple set of commands to do so....

The tables are HUGE and have to processed quickly....

Thanks!!!!

Tommy