Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFun challenge! Most of the questions I get are helping troubleshoot problems and issues that have arisen in a workflow or macro. It is a good skill to practice troubleshooting!
This was a great exercise. I would really like to see some comments on the process people used to troubleshoot the macro.
1. Missing close bracket on "Close Date" in Formula(5)
2. Incorrect field renaming for "Open Date" and "Close Date" in Select(17)
3. Target and Source inputs swapped on Append Fields(11) [Looks like other people fixed this by allowing all appends]
4. Action(10) not connected to Text Input(9)
5. Incorrect date formats for conversion in DateTime(15) and DateTime(16)