Hai,
 I have a problem with the difference between two dates.
I need the out put in month.days
ie. for eg:
     2.5 months
With dateDiff function it is not possible.
Can u help me..

Thanking u

regards,

Bimal

Why isn't it possible?

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

As far as I know, the DateDiff function always rounds down to the closest month so 15 weeks would be the same as 16 weeks in terms of months.

Would something like:
--------------------------------------------------------
Dim MonthsDiff as Double

MonthsDiff = FormatNumber(((DateDiff(DateInterval.Day, Date1, date2) / 7) / 4.33), 2)
--------------------------------------------------------

work for you?

J

Hai Levy,

Thanks for your reply.
But the problem is still their.
Your solution only give approximate result.
ie. for eg:
Diff b/w 1/1/2003 and 31/12/2003 will give
     result as ==> 12.04 that means 12 months 4 days.
Here actual value is 12 months 0 days
Check it..

Is their any accurate methods.

Hoping to here soon...
Thank you

regards

Bimal

I never know that there is a method to check date differences. but if I were you, I would do it manually.

Actually, that was me that replied, not Hal.

I know it won't be exact but it wasn't supposed to be. Every month has a different number of days to it (28, 30, 31) plus you have to account for leap years, so you will likely have to write a function that does a little more work than this. I thought all you wanted was an estimation of the total months - in your first example (2.5) months or roughly 2 1/2 months.

J