![]() |
Increment a Variable Defined Date by 1 day
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 |
Increment a Variable Defined Date by 1 day
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 |
Increment a Variable Defined Date by 1 day
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 |
All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com