Hello,

  How can i get the exact months difference between two dates. I tried this


dim dt1,dt2
dt1=#3-Jan-2005#
dt2=#1-Feb-2005#
response.write datediff("d",dt1,dt2)


Its still displaying 1. Actually its not 1.

datediff will find based on the months in the two dates.
Event the dt1 is #31-Jan-2005#, it displays 1.

??????

ii believe you have to change this line:

response.write datediff("d",dt1,dt2)

to

response.write datediff("m",dt1,dt2)

Hello,

  Thanx for the reply. I mistakened here. Actually it is "m" only.

Any sollution???

what do you mean by *exact months difference*?

<%
Date1 = #01/01/2005#
Date2 = #02/01/2005#

MonthDiff = DATEDIFF("M",Date1,Date2)

Response.Write(MonthDiff)
%>
This shold return 1, what's problem? are you saying that
If Date1 = 01/01/2005 and Date2=01/15/2005 then monthdiff should be about 0.48

No,

  Suppose the first date is 25-Jan-05
and the second date is 1-feb-05

If i want to find the months diff between these two,

  it gives 1. But actually it is less then 31 days(jan 31) it should return 0 instead of 1. If the second date is 10-mar-05,
it should return 1 only(not 1.x).

i think u got it.