First and Last Day Of Month

[Mark Gambo]

Well the first day of the Month should be the first, right ?
and you could use the following to find the last day of the month:

Dim dtDate as Date
dtDate = "09/09/2005"
 
DateAdd("m",DateSerial(Year(dtDate), Month(dtDate), 1) - 1