Calculating Last day of Month

[Capilano]

Hi...

Years ago, in MS-97, we used to be able to calculate the last day of any month using LenMonth. LenMonth(1stDayOfMonth) would give us the last day of month.

Recently, I have been asked to design a new system and I have not been able to identify whether Microsoft retained this feature in subsequent versions of Access.

If I know the first day of a month, does anyone know a quick method for determining the last day of the month?

Thanks

Pat

 

[RuralGuy]

Here's a link you will want to bookmark: A plethora of date functions

 

[Capilano]

Solution Found

Hi... I finally located a solution on the MS website to my problem. Here is the syntax:

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

Problem solved!

Pat
http://www.access-programmers.co.uk/forums/images/smilies/redface.gif