General information
Title:
Code for a max expiration date???
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only