How to calculate the end date of a month?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 14 Nov 2006 08:44 GMT

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!

Reply to this Message

Eric - 14 Nov 2006 09:31 GMT

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

Thanks.

> Does anyone know if there is an easy way to calculate the end date of a month?
>
[quoted text clipped - 3 lines]
>
> Thanks for any help or tips!

Reply to this Message

Klatuu - 14 Nov 2006 15:35 GMT

Just to make sure you got what you were after:

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

> Please forgot what I just posted.
> I found the solution by using the DateSerial function from Microsoft Access.
[quoted text clipped - 8 lines]
> >
> > Thanks for any help or tips!

Reply to this Message