Finding Last Date of the month

I need to find the last day of the month of the next month of the variable date.  For instance if the date is 01/31/2007 I need it to come back 02/28/2007.  If the date is 12/31/2006 I need it to come back 01/31/2007.

mgmhicksAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
DateSerial(Year(StartDate), Month(StartDate) + 2, 0)

Kevin
0
 
mgmhicksAuthor Commented:
Thank you.  Straight and to the point.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.