I want to create an ‘is active’ field that looks at whether today’s date is greater than a ‘start date’ and less than an ‘end date’. Unfortunately, this does not seem possible without using ‘today()’ in a calculated field.
I am aware of the time until and time since functions, but they cannot be used within a calculated field, and if used on their own, the resulting fields cannot be used within a calcualtion.
while im aware of a similarly titled idea, it was marked as complete because ‘time since’ was sufficient for this use case, however, the original request as titled, still hasn’t been delivered 4 years later.