We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Last week's solution can be found HERE!
Create a macro that generates a table with the date and the day of the week for all dates from a given starting date to today. The user should be able to select the start date.
Bonus 1: Add a selection that will allow the macro user to select whether or not to include weekends.
Bonus 2: Create a duplicate macro that's encrypted so that no changes can be made. Leave the first macro on your canvas unencrypted so other challenge-takers can observe how your macro was built.
First time attempting the weekly challenge! I attached my macro (both encrypted and not) to this post.
EDIT: When I am creating the macro, I can use this expression in the Generate Rows tool for the Initialization Expression: "%Question.StartDate%" to get the initial start date from the date interface tool. However when I run the macro, I noticed that the initialization expression somehow automatically gets changed to whatever I set the value to in my workflow configuration. Does anyone know why this happens?
This one was relatively quick/easy for me - but mostly because I have a lot of exposure to dates and table creation.
My solution! Ah, it feels good to finally be caught up on Weekly Challenges after my 3-week vacation... Which, if I use this spiffy new macro, I can use it to see a list of exactly which days I was on vacation! Cheers!
I had hoped to leverage the Detour tools, but they were throwing errors at me, so went another route. This way took fewer tools in the end, but the Detours make more logical sense. If I get that method working, I'll post too.
Happy with the efficiency of only 3 main tools in the workflow + 2 interface interactions +1 action + 1 output.
And I learned something new and powerful!! Didn't know one could encrypt macros.