For Checkboxes? Formula > Workflow. Still.

posted Apr 21, 2011, 2:46 PM by Ezra Kenigsberg   [ updated Apr 21, 2011, 2:56 PM ]
Recently re-read the specs on how Workflow Field Updates work and thought, 

"Hey, this is a lot more robust than I remember it. I shouldn't be bothered by the lack of a checkbox formula field; I can keep a checkbox populated with the proper value through Workflow Field Updates!"

Meh. It took me about two minutes of testing to determine that, nope, Workflow Rules aren't robust enough to keep a checkbox populated with the proper value.

In my case, I wanted to check/uncheck an "Active?" checkbox depending on whether today's date fell within a range dictated by two Date fields called "Start Date" and "End Date".

Alls I needed to do was set an End Date before today and the damn thing didn't work right. well, poop.