|
WANTS TO MAKE SOFTWARE WITHOUT KNOWLEDGE OF PROGRAMMING? CLICK HERE
The DateDiff function returns the number of intervals between two
dates. The DateDiff function is a great way to calculate the
interval period between two dates. If you set the interval parameter
to m for months the function will return the amount of months between
the two dates. The table below lists the interval periods you can
set for the interval parameter.
The Syntax of DateDiff function is :-
| DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]]) |
Its Description is :-
| Parameter |
Description |
| date1,
date2 |
Required.
Date expressions. Two dates you want to use in the calculation |
| firstdayofweek |
Optional. Specifies the day of the week.
Can take the following values:·
- 0 = vbUseSystemDayOfWeek - Use National Language Support
(NLS) API setting.
- 1 = vbSunday - Sunday (default).
- 2 = vbMonday - Monday.
- 3 = vbTuesday - Tuesday.
- 4 = vbWednesday - Wednesday.
- 5 = vbThursday - Thursday.
- 6 = vbFriday - Friday
- 7 = vbSaturday - Saturday
|
| firstweekofyear |
Optional. Specifies the first week of the year.
Can take the following values:·
- 0 = vbUseSystem - Use National Language Support (NLS)
API setting.
- 1 = vbFirstJan1 - Start with the week in which January
1 occurs (default).
- 2 = vbFirstFourDays - Start with the week that has at
least four days in the new year.
- 3 = vbFirstFullWeek - Start with the first full week of
the new year
|
Example#1 :-
Code :-
document.write(Date & "<br />")
document.write(Date Diff("m",Date,"12/31/2002")&"<br/>")
document.write(Date Diff("d",Date,"12/31/2002")
& "<br />")
document.write(Date Diff("n",Date,"12/31/2002"))
Output :-
1/14/2002
11
351
505440 |
Example#2 :-
Code :-
document.write(Date & "<br />")'
Note that in the code below'
is date1>date2
document.write(DateDiff("d","12/31/2002",Date))
Output :-
1/14/2002
-351 |
Example#3 :-
Code :-
'How many weeks (start on Monday),'
are left between the current date and 10/10/2002
document.write(Date & "<br/>")
document.write(DateDiff("w",Date,"10/10/2002",vbMonday))
Output :-
1/14/2002
38 |
Example#4 :-
Code :-
<%
Response.write DateDiff("m","01/01/04",date)
& " Months"
'date function returns todays date so its difference between
01/01/04 & today
%>
Output :-
28 Months |
|
