I'm trying to send a notification to a group of people if an event has not occurred for 28 days. This can't be too complicated and after reading a bunch of helpful questions here, I have come up with the following:
if (Yearday('*') - Yearday(FindEq('\Holland Energy Park\00 Balance of Plant\00GHF - Fire Water System\00GHF00AP\00GHF00AP001 - Diesel Fire Pump|Pump Status', '*', '-100d', "RUNNING"))) > 28 then "true" else NoOutput()
The only problem is the year change, this approach will fail in January. Any ideas on a better way to accomplish this or get around the January issue?