|
Learning ASP Free Course Basics Functions SQL Commands Sample Code Servers / Setup Host Reviews Server Setup Error Tips Contract ASP Development Search For: 
|
DateDiff Date Function
With DateDiff, you can determine the difference between two dates. This lets you see how long it's been since someone last logged in and much more.
The format of the DateDiff function is
DateDiff(code, date1, date2)
Code comes from the table below and indicates what unit of time you are wanting the difference measured in:
| Code | Time Span |
| yyyy | Year |
| q | Quarter |
| m | Month |
| y | Day of year |
| d | Day |
| w | Weekday |
| ww | Week of year |
| h | Hour |
| n | Minute |
| s | Second |
The two dates are the dates which you will be comparing to each other
So to take today's date, a "Last Logon" date and see how many days it's been since your user logged onto your site, you would use:
DateDiff("d", LastLogon, Now())
ASP Date and Time Functions
Bookmark this site so you can reference it any time you have ASP questions in the future!
All content copyright © 2012 Minerva WebWorks LLC. All rights reserved.
|
Ebooks Intro to ASP ASP SQL DB Members Shopping 
Romance Tips Irish Romance Italian Romance French Romance
|