Compare date difference in MS Access with ASP

[rockysg]

I need to create a page which takes input from a field from MS Access Database which has one date and there is another field in the MS Access Database which has another date.

I want to find the date difference in no of days from these two fields using ASP VBScript. Kindly Help me out.

[sashi]

Hi there,

<%
date1 = dareRS.Fields("dtFirstDate")
date2 = dareRS.Fields("dtSecondDate")
%>

<%=DateDiff("m",date1,date2)%>


The "m" specifies month. Here are a complete list of the other options available.

Setting Description
yyyy - Year
q - Quarter
m - Month
y - Day of year
d - Day
w - Weekday
ww - Week of year
h - Hour
n - Minute
s - Second

good luck my fren..