>>>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)
>
>That's what I thought... I had IF GOMONTH(loaddate,12) >= DATE()
>
>Thanks..
>
>Tommy
You should really have the field all by itself on the left side for rushmore to really be used.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers