duration between dates

rjkulkarni2001 · January 5th, 2006, 08:09 AM

hello,
i want to find the duration between two dates, and it should be in format as given below,
date1:12/12/2005 dd/mm/yyyy format
date2 :12/01/2006
then duration should be difference of two dates
and format like
0 years,1 month 0 days

thank u

mat41 · January 5th, 2006, 07:19 PM

Please do not cross post:

http://p2p.wrox.com/topic.asp?TOPIC_ID=38322

Your other post asks for a 'in asp.net with vb.net code behind' solution - what exactly are you after?

If its classic ASP/VBScript you could use the dateDiff function:

------------cut n paste code-----------------
<%
  dim dateOne,dateTwo
  dateOne = "12/12/2005"
  dateTwo = "12/01/2006"
  response.write DateDiff("yyyy", dateOne, dateTwo) & " Years, " & DateDiff("m", dateOne, dateTwo) & " Months, " & DateDiff("d", dateOne, dateTwo) & " Days"
%>
---------------------------------------------

Wind is your friend
Matt