Rabbit, the poster is using the European date formatting, so the month is in the middle.
The solution is to use the DateAdd function. It looks like this:
- NewDate = DateAdd('m',1,OriginalDate) ' 1 month being added to OriginalDate
You may also want to look at function DateSerial, as it is often helpful in creating dates. For your problem it could be used like this:
- NewDate=Dateserial(Year(OriginalDate),Month(OriginalDate+1),Day(OriginalDate)
-
DatePart is also a helpful function. Have fun learning about these helpful functions :)
Jim