Increase date's Day by 7 at end of the month

[Brian]

Hello,

I'm trying to get the %DATE% variable to increase the dates DAY by 7. I can do that part no problem but the problem being if the date's day is 27 for example and there are only 28 days in the month....how Can I get this to increase the month as well as the date corresponding to each months variable days in the month.

For example: I want 05/27/2023 to go to 06/03/2023

[Steve]

Hi Brian,

Mini Mouse Macro does not have date math so working with date can be tricky unfortunately.

Other than the %DATE% variable we also have:

  - Year value %DATE_Y%
  - Month value %DATE_M%
  - Day value %DATE_D%
  - Hour Value %TIME_H%
  - Minute Value %TIME_M%
  - Second Value %TIME_S%
  - Millisecond Value %TIME_MS%
The only thing I can think of right now is to use some logic to determine the current month with %DATE_M% and then using some further logic within MMM to define your math and new date accordingly.

But...thank you for your post, you are right MMM should have date math and we shouldn't have to write complex logic to so simple date math. I will add this into the next update. Thanks


Cheers,
Steve.

[Brian]

Awesome to hear to that this is one of the greatest programs ever made it's really quite amazing and I use it daily at work to batch certain program tasks saving me so much time!!