DateDiff Date Function

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:

CodeTime Span
yyyyYear
qQuarter
mMonth
yDay of year
dDay
wWeekday
wwWeek of year
hHour
nMinute
sSecond


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())

Date and Time Functions

Introduction to ASP Ebook

Download this ebook to get everything you need to know about learning ASP - from a step by step tutorial to function lists, sample code, common errors and solutions, and much more! 101 pages.




RSS
Related Articles
Editor's Picks Articles
Top Ten Articles
Previous Features
Site Map





Content copyright © 2023 by Lisa Shea. All rights reserved.
This content was written by Lisa Shea. If you wish to use this content in any manner, you need written permission. Contact Lisa Shea for details.