|
Learning ASP
Servers / Setup
Contract ASP |
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
All content copyright © 2008 Minerva WebWorks LLC. All rights reserved.
|
Ebooks Intro to ASP ASP SQL DB Members Shopping 
Romance Tips Irish Romance Italian Romance French Romance
|
