>>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
Tommy Tillman A+ NetWork+ MCP