DateAdd("yyyy", 3, "22/11/2003") | would return '22/11/2006' |
DateAdd("q", 2, "22/11/2003") | would return '22/05/2004' |
DateAdd("m", 5, "22/11/2003") | would return '22/04/2004' |
DateAdd("n", 51, "22/11/2003 10:31:58 AM") | would return '22/11/2003 11:22:58 AM' |
DateAdd("yyyy", -1, "22/11/2003") | would return '22/11/2002' |
Value Explanation
yyyy Year
q Quarter
m Month
y Day of the year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second