Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Web, Visual Basic
Expertise: Intermediate
Mar 4, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Manipulate Dates With VBScript's DateAdd Function

Browsers Targeted: Internet Explorer 4+

Dates can be a pain to deal with when working with scripting. Fortunately VBScript 5.0 supports a number of different functions that can simplify the process of manipulating dates. For example, consider the case where you want to retrieve the date one month from now. While you could create a date object, parse it into its individual components, add one to the month, set the month to "1" if you're in the month of December and so forth, you can take advantage of the VBScript 5.0 DateAdd() function. This function lets you specify an interval and a time unit (such as month), add it to a date, and create a new date.

<script language="VBScript">
	document.write "Current Date:"+cstr(curDate)+"<br/>"
	document.write "Date + 1 Month:" + cstr(newDate)+"<br/>"
	document.write "Date - 1 Month:" + cstr(newDate)+"<br/>"

The DateAdd() function can take one of several interval tokens:

Interval Token Interval Meaning Function Call
N/A Now Now
yyyy Year dateAdd("yyyy",1,Now)
q Quarter dateAdd("q",1,Now)
m Month dateAdd("m",1,Now)
y Day in Year dateAdd("y",1,Now)
w weekday dateAdd("w",1,Now)
ww week in year dateAdd("ww",1,Now)
h Hour dateAdd("h",1,Now)
n Minute dateAdd("n",1,Now)
s Second dateAdd("s",1,Now)
Kurt Cagle
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date