How do I get my date formula to stop at zero?
So here is my current formula: WeekdaySub (ToDate(), Today()) Once we're past the Training Start Date it calculates negative values, however I would like to stop it at 0 since there has been a requ...
Forum Discussion
Ron, you just need an if formula to set it to zero when it goes negative. See the following as an example.
var number daysTillTraining = WeekdaySub(ToDate(), Today()); If ( $daysTillTraining < 0 ,0 ,$daysTillTraining )