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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

first and last day of month -1 1

Status
Not open for further replies.
2009luca

2009luca

Programmer
Jul 27, 2013
222
IT
Based the current date how to calculate the furst and last day of month -1?

Example:
now
14/03/2014

calculate first and last day of febrary.

Tks.
 
Sort by date Sort by votes
hi,
Code: 
dFirst = DateSerial(Year(Date), Month(Date)-1, 1)
dLast = DateSerial(Year(Date), Month(Date), 1)-1


Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
COUNT all items in trteeview in last level 1
Replies
4
Views
254
2009luca
2009luca
sal21
  • Locked
  • Question
delete first line in txt and rewrite
Replies
2
Views
116
sal21
sal21
sal21
  • Locked
  • Question
LAST DATE OF MODIFIED FILE on WEB 1
Replies
4
Views
147
strongm
strongm
2009luca
  • Locked
  • Question
SORT msflexgrid column 1 with decimal number 1
Replies
4
Views
204
2009luca
2009luca
Ken01
  • Locked
  • Question
Extraction of Picture box point / pixel colors. 3
Replies
13
Views
1K
klima
K

Part and Inventory Search

Sponsor

Back
Top