>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
If you have a index on the field then you could use a select or SET key statement to find the records you want with the greater than statment
loaddate > GOMONTH(DATE(), -12)
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers