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 derfloh 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
Joined
Feb 4, 2003
Messages
3
Location
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 Question
change copy count windows 10.
Replies
2
Views
318
G Shen
G Shen
puforee
  • Locked
  • Question Question
Using VBA to store a Access report to a local C: drive that works for different computers
Replies
1
Views
303
dhookom
dhookom
DylaBrion
  • Locked
  • Question Question
Excel VBA User Form Centering when using two Monitors
Replies
7
Views
590
DylaBrion
DylaBrion
sxschech
  • Locked
  • Question Question
Two Outlook Questions on email from Access VBA (ReplyAll, Attachments)
Replies
2
Views
329
sxschech
sxschech
bradles
  • Locked
  • Question Question
Count current database connections?
Replies
5
Views
677
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top