dateadd()

[Øyvind Isaksen]

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

[Ray at]

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" <oyvind@webressurs.no> wrote in message
news:%23QSt4wNlDHA.2140@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
>
>

[Tom B]

DateNew=DateAdd("d",1,DateOld)

"Øyvind Isaksen" <oyvind@webressurs.no> wrote in message
news:%23QSt4wNlDHA.2140@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
>
>

[Evertjan.]

Tom B wrote on 17 okt 2003 in microsoft.public.inetserver.asp.general:

> DateNew=DateAdd("d",1,DateOld)
>

So true ;-)

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Ken Schaefer]

The function should be culture-aware. There are plenty of cultures that have
alternate numeric delimiters (eg . for thousands, and commas for decimals),
date delimiters, currency formats etc. VBScript doesn't care.

Cheers
Ken

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:uWotR2NlDHA.1740@TK2MSFTNGP12.phx.gbl...
: 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" <oyvind@webressurs.no> wrote in message
: news:%23QSt4wNlDHA.2140@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