SQL PHP HTML ASP JavaScript articles and free scripts to download

Finding out difference in two dates by using DateDiff function

We can find out the difference between two dates by using DateDiff function of VBScript used in ASP. DateDiff() finds out the difference of the dates based on the required date part like month, year, days etc. Here is the basic syntax of DateDiff function.

DateDiff(date_type, date1, date2, first_dow, first_woy)

Here date_type is the date part to be considered while returning the output. This can be month, day, year etc. The table with different values of date_type is listed at the end. Next two arguments date1 and date2 are two date values for which difference is to be calculated. The other two arguments first_dow and first_woy are optional arguments. First_dow takes the value to specify what is to be taken as first day of the week and the other value first_woy takes the value of first week of the year.

Let us see this example code on uses of DateDiff to find out difference in months between two dates.

Dim d_diff
Response.Write "Today date is " & d_today & "<br>"
d_diff=DateDiff("m",#2/28/03#,#2/28/06#)
Response.Write "Difference " & d_diff & "<br>"

The output of the above by changing the value of date_type we can find out the difference in days, years, weeks etc. Table for different date_type values
ValueMeaning
"yyyy"Year
"m"Month
"d"Day
"h"Hour
"n"Minute
"s"Second
"w"Weekday
"ww"Week of the year
"q"Quarter

Be the first to post comment on this article :


Google+

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer