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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count months between two different years.

Status
Not open for further replies.
Shout

Shout

Programmer
Feb 4, 2003
3
NO
Hi, how do I get the correct number of months when calculating months between a "yrmo"-field. Eksample:
200510 and 200410.

Thanks.
 
Sort by date Sort by votes
Hi
I think you need DateDiff. The example above would, perhaps, look like this:
Code: 
strDate1 = "200410"
strDate2 = "200510"
dte1 = DateSerial(Left(strDate1, 4), Mid(strDate1, 5, 2), 1)
dte2 = DateSerial(Left(strDate2, 4), Mid(strDate2, 5, 2), 1)

intDiff = DateDiff("m", dte1, dte2)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

G Shen
  • Locked
  • Question
change copy count windows 10.
Replies
2
Views
208
G Shen
G Shen
puforee
  • Locked
  • Question
Using VBA to store a Access report to a local C: drive that works for different computers
Replies
1
Views
204
dhookom
dhookom
DylaBrion
  • Locked
  • Question
Excel VBA User Form Centering when using two Monitors
Replies
7
Views
357
DylaBrion
DylaBrion
sxschech
  • Locked
  • Question
Two Outlook Questions on email from Access VBA (ReplyAll, Attachments)
Replies
2
Views
231
sxschech
sxschech
bradles
  • Locked
  • Question
Count current database connections? 1
Replies
5
Views
506
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top