How to calculate the end date of a month?

E

Eric

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!
 
E

Eric

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

Thanks.
 
K

Klatuu

Just to make sure you got what you were after:

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