ASP: how to use dateadd
ASP is a powerful tool. Here, as usual, we are talking about a VBScript function that let us manipulate dates: DateAdd.
Whenever we need to perform operations on a date, we can benefit from the use of the this function. In the following post we are going to see how to use it.
It is mainly used to calculate a future date, starting from a given date, however we can use it even to calculate a date in the past. The function is obviously taking into account the calendar, considering the number of days in a month accordingly.
The function syntax is:
The interval parameter can be:
The interval_value is the number of interval we want to add. Great is the possibility to use positive or negative values. The positive value will be added to the original date, the negative will be added but - if you know maths a little - it will make our date go back in time.
Finally the date parameter: it represent the date from which to start the calculation, the date to which the interval will be added.
Starting from a simple one, we can add one year to a given date:
Remember that a date includes the time. That means we can can add an hour to a given date:
Isn't it simple?
If we use negative numbers, we are going back in time:
And that is all. Next time we are going to see the DateDiff function, which is quite handy...
Whenever we need to perform operations on a date, we can benefit from the use of the this function. In the following post we are going to see how to use it.
DateAdd
DateAdd is used to add a specific time interval to a date. The output is a new date, which value is the sum of the original date, plus the time interval.It is mainly used to calculate a future date, starting from a given date, however we can use it even to calculate a date in the past. The function is obviously taking into account the calendar, considering the number of days in a month accordingly.
The function syntax is:
DateAdd(interval, interval_value, date)The interval parameter can be:
- 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 interval_value is the number of interval we want to add. Great is the possibility to use positive or negative values. The positive value will be added to the original date, the negative will be added but - if you know maths a little - it will make our date go back in time.
Finally the date parameter: it represent the date from which to start the calculation, the date to which the interval will be added.
Example
Let's see an example.Starting from a simple one, we can add one year to a given date:
<%response.write(DateAdd("yyyy",1,"03-Jul-12"))%>Remember that a date includes the time. That means we can can add an hour to a given date:
<%response.write(DateAdd("h",1,"03-Jul-12 07:00:00"))%>Isn't it simple?
If we use negative numbers, we are going back in time:
<%response.write(DateAdd("yyyy",-1,"03-Jul-12"))%>And that is all. Next time we are going to see the DateDiff function, which is quite handy...