|
Learning ASP Free Course Basics Functions SQL Commands Sample Code Servers / Setup Host Reviews Server Setup Error Tips Contract ASP Development Search For: 
|
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:
| 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())
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
|