DateAdd Date Function
The DateAdd functon lets you add a certain amount of time to any date. You can determine what will be a week from now, what was 3 days ago, or any other difference.
The format of the DateAdd function is
DateAdd(code, count, date)
Code comes from the table below and indicates what unit of time you are adding to your initial date:
Count is the number of those units you will be adding - 3 days, 4 hours, 1 month. This can be negative if you want to go backwards in time.
Date is the starting date you wish to begin with.
So to take today's date and figure out what the date was one month ago, you would use
DateAdd("m", -1, Now())
Date and Time Functions
The format of the DateAdd function is
DateAdd(code, count, date)
Code comes from the table below and indicates what unit of time you are adding to your initial date:
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 |
Count is the number of those units you will be adding - 3 days, 4 hours, 1 month. This can be negative if you want to go backwards in time.
Date is the starting date you wish to begin with.
So to take today's date and figure out what the date was one month ago, you would use
DateAdd("m", -1, 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. |
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.