Add to a date

[craig_phillips2]

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

Dim oldDate as Date

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

Hope you can help

[chrisjk]

Use the DateAdd function

[jim mcnamara]

look up DateDiff and DateAdd in help.

[chrisjk]

?

[craig_phillips2]

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?

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

[chrisjk]

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

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