build a date based on a given month and year, with the day = 1. (ex: 1-OCT-2006)
Use the DateAdd function to add 1 Month to this date (ex: 1-NOV-2006)
use the dateadd function to add -1 day to the prior result. (ex: 31-OCT-2006)
The result is the last of the month.
Last edited by loquin; 10-18-06 at 16:47.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert