How to calculate the end date of a month?

[Guest]

Does anyone know if there is an easy way to calculate the end date of a month?

When I'm reading dates in a recordset, for example 10/01/2006 then I want to
store the end date of October (10/31/2006) in another date variable to do
other calculations.

Thanks for any help or tips!

 

[Guest]

Please forgot what I just posted.
I found the solution by using the DateSerial function from Microsoft Access.

Thanks.

 

[Guest]

Just to make sure you got what you were after:

DateSerial(Year(Date),Month(Date)+1,0)