Member Avatar for PinoyDev

How to get the difference of the month from the date specified.
Example:

date1.value="5/1/2010"
date2.vale ="5/31/2011"

it should give a result of 12.

thank you for helping.!

Edited by PinoyDev because: n/a
  • 2 Contributors
  • 4 Replies
  • 106 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by PinoyDev

Recommended Answers

All 4 Replies

Member Avatar for Pgmer 
Dim resultdate As Long

        resultdate = DateDiff(DateInterval.Year, date2, date1)

Try this...

Member Avatar for Pgmer

Sorry u need months right? try this

resultdate = DateDiff(DateInterval.Month, date1, date2)

Member Avatar for PinoyDev

Sorry u need months right? try this

resultdate = DateDiff(DateInterval.Month, date1, date2)

Thanks. But i got these error!

"Object required" even if the name of the date control is correct..

msgbox datediff(dateinterval.month,dt1.value,dt2.value)
Member Avatar for PinoyDev

Thanks. But i got these error!

"Object required" even if the name of the date control is correct..

msgbox datediff(dateinterval.month,dt1.value,dt2.value)

I got it.. These works!

dim getmonthdiff as long

getmonthdiff=datediff("m",dt1,dt2)

msgbox getmonthdiff

thx..

Edited by PinoyDev because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.