I’m trying to add a calculated field on a (contract) type to indicate if that contract is active, based on the rule that the date needs to be in between dates in 2 other fields.
But whatever I do, my calculated field seems to be giving false as response. As a test, I added some fields to check the behavior, and both seem to be false when I do a fetch on the records:
afterStart : boolean calc “(now() >= startDate)”
beforeStart : boolean calc “(now() < startDate)”
Am I missing something regarding the use of now() or boolean values in a calculated field? Does comparison just not work with datetime values?