I'm maintaining a program in 2.6 which runs a report of all license with an expiration between 2 periods. I'm running into a problem when the license holder has renewaled the license in the same fiscal year. They now have 2 records, one which expires 9/14/02 and the other 9/14/03. When the program is run, it says the 9/14/02 needs to be renewaled even though there is another record out there already renewaled. There is no chance to change the data.

Here's what I wanted to do:
select * from table where max(expdate) > 9/01/02 and max(expdate) < 9/30/02.

Of course, this doesn't work. Does anyone have any suggestions?

Sunshine