Add to a date

Can anybody tell me how to add to a date. I think the dates are actually stored as doubles but what i want to know is what a

second, minute, hour, day, month or year would be.

i have the following

Code:

---

Dim oldDate as Date

If Now() < oldDate + [what i want to add to the date] Then
  DoEvents
End If

---

Hope you can help

Use the DateAdd function

look up DateDiff and DateAdd in help.

?

Cheers

I dont have the msdn so what goes in the Interval and Number parts. I presume the Date is the date you want to add the interval or number to?

Code:

---

Function DateAdd(Interval As String, Number As Double, Date)

---

Interval is a code that determines what you want to add, e.g. Days, Months, Years etc. Number is how many Interval's you want to add to Date

Quote:

---

The interval argument has these settings:

Setting Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second

---