Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAhaha - I had a lot of failed branches to the delete at the end.
This one was fun. Rarely have a chance to use the JSON tool.
Nice to get the JSON Parse tool off the shelf - it was getting dusty up there.
All,
My solution using a Text-to-Column, 2 DateTime, and a formula tool.
-I also assumed that if there were two condition types, that we use the second.