Ran a few tests of the below and I think it will work for your use case described. Essentially it reads that the First day of todays date has to be on or after the first day of the week when it starts, and the last day of the week of the outage has to be on or after the last day of the week when it ends. I ran a couple sim
Formula-checkbox
If(
FirstDayOfWeek(Today()) >= FirstDayOfWeek([Start Date]) and
LastDayOfWeek(Today()) <= LastDayOfWeek([End Date]),
true,false)
Chayce Duncan | Technical Lead
(720) 739-1406 |
chayceduncan@quandarycg.com Quandary Knowledge Base
