The first issue is that the first argument needs to be a string, not an
empty variable, so you'd do:
DateNew = DateAdd("d", 1, DateOld)
But I don't think it'll work with that dot format. (Whoever started putting
dots in dates and phone numbers should be eliminated!) Replace the "." with
"/" before you use DateAdd.
Ray at work
"Øyvind Isaksen" <oy****@webressurs.no> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Hi!
I need to add 1 day to a specific date.
The date have is stored in a variable called "DateOld". The value of the
variable have this syntax: mm.dd.yyyy.
The new date is the variable called "DateNew".
This is my code that dont work:
DateNew = DATEADD(d,1,DateOld)
What is wrong here??
I get this error message: Invalid procedure call or argument: 'DATEADD'
Regards,
Øyvind Isaksen
Norway