@Peter, iterating through db.Views is kind of expensive. Better to hard-code the view names or store them in a profile, some such thing.
Also, as others have pointed out, if the agent skips a day for whatever reason there's a problem. Better if you search for the ['s in the formula and see whether what comes before the next ] looks like a date.
And you don't always want today's date in there.
And there's also the matter of @Today used in a column formula.
@Peter, iterating through db.Views is kind of expensive. Better to hard-code the view names or store them in a profile, some such thing.
Also, as others have pointed out, if the agent skips a day for whatever reason there's a problem. Better if you search for the ['s in the formula and see whether what comes before the next ] looks like a date.
And you don't always want today's date in there.
And there's also the matter of @Today used in a column formula.