I have defined a date variable with a date [MM/DD/YYYY] as the first day of
the week [Monday]. I would like to increment the date variable by 1 day.
This should be straightforward but I am not finding it in my reference book.
Any help would be appreciated.

Example:
strdate = 10/11/2004
I need:
strdate +1 = 11/12/2004

How do you come to the conclusion that
10/11/2004 plus 1 is 11/12/2004.

If you meant 10/12/2004, then

strDate + 1 gives you the date 1 day later than 10/11/2004 as long as
strDate is a date variable, or a variant loaded with a date.

--

HTH

RP

"JimI" wrote in message
...
I have defined a date variable with a date [MM/DD/YYYY] as the first day
of
the week [Monday]. I would like to increment the date variable by 1 day.
This should be straightforward but I am not finding it in my reference
book.
Any help would be appreciated.

Example:
strdate = 10/11/2004
I need:
strdate +1 = 11/12/2004

Bob,

Didn't mean to confuse anyone "11/12/2004 was a typo. I was looking to
increment by one day. Thanks for your answer. I had my variable incorrectly
identified as a "single". Fixed and all is well.

Thanks!!!!

"Bob Phillips" wrote:

How do you come to the conclusion that
10/11/2004 plus 1 is 11/12/2004.

If you meant 10/12/2004, then

strDate + 1 gives you the date 1 day later than 10/11/2004 as long as
strDate is a date variable, or a variant loaded with a date.

--

HTH

RP

"JimI" wrote in message
...
I have defined a date variable with a date [MM/DD/YYYY] as the first day
of
the week [Monday]. I would like to increment the date variable by 1 day.
This should be straightforward but I am not finding it in my reference
book.
Any help would be appreciated.

Example:
strdate = 10/11/2004
I need:
strdate +1 = 11/12/2004