Challenge #86: Create a Macro that Generates Past Dates

[jasperlch]

Solution attached.

[JosephSerpis]

Challenge Completed

[jamielaird]

Here's my solution:

Spoiler

Calendar icon from https://www.flaticon.com/free-icon/calendar_138780#term=calendar&page=1&position=40

EDIT: I seem to have solved this one TWICE. My tracking spreadsheet is clearly not as perfect as I thought.

[kat]

Thought my workflow was pretty cool, but then I saw other people be so much more efficient. At least I finally got to use detour - will be making much more use of that in future! But so much more efficient to just use the checkbox output in the filter... as well as having the date select go straight to the generate rows tool.

Spoiler

[debn]

Can you please post the files in version 11?  My organization has not updated to 2018 yet.  

thank you,

[tcroberts]

Here's my solution:

Spoiler

Not exactly optimal, since I generate all dates then drop if the box is checked, but it works well enough for pretty large ranges of dates so I was satisfied.

Seemed fairly simple for a challenge tagged Advanced though.

[danilang]

The macro and the encrypted one

Spoiler

Dan

[KOBoyle]

Solution attached.

Spoiler

[Gauthier_B]

Spoiler