• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

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.

0
mgmhicks
Asked:
mgmhicks
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
DateSerial(Year(StartDate), Month(StartDate) + 2, 0)

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

0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now