Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Getting End of Current Month Date
- Thread starter TheClaw
- Start date
MatsHulten
Programmer
Code:
dateadd("d", -1, dateadd("m", 1, dateadd("d", -day(date)+1, date)))-Mats Hulten
- Thread starter
- #3
MichaelRed
Programmer
Well, at least a couple of dateadd's more than necessary:
? Dateserial(Year(Now), Month(Now) + 1, 0)
5/31/01
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
? Dateserial(Year(Now), Month(Now) + 1, 0)
5/31/01
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
MichaelRed
Programmer
P.S. this has been covered in some detail in these forumns. If you search for various "date" related topics, you can find an explination of why this works.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
- Status
