DateAdd (interval, number, date) 'all three are mandatory parameters ‘interval – can be one of the following listed in bullet points ‘number – can be any +/- integer 'date – can be variant or literal, represents starting date
Interval values
- d – day of the year.
- m – month of the year
- yyyy -Year
- w -Weekday
- ww -week
- q -quarter
- h -Hour
- n -Minute
- s –Second
‘examples MsgBox (DateAdd("yyyy", 1, #1/1/2040#)) '1/1/2041 MsgBox (DateAdd("q", 1, #1/17/2040#)) '4/17/2040 MsgBox (DateAdd("d", -10, #1/17/2040#)) '1/7/2040 MsgBox (DateAdd("ww", 1, date1)) '1/6/1900 MsgBox (DateAdd("h", -1, "01-Jan-2040 12:00:00")) '1/1/2040 11:00:00 AM MsgBox (DateAdd("n", 1, "01-Jan-2040 12:00:00")) '1/1/2040 12:01:00 PM MsgBox (DateAdd("s", 1, "01-Jan-2040 12:00:00")) '1/1/2040 12:00:01 PM
Advertisements