I am using this in a field to pull in Active or Expired
If (Get ( CurrentDate ) > End Date;"ACTIVE"; "EXPIRED")
but it isn't working.
That Auto Enter -> "Calculated Value" box won't dynamically update. The easiest way around it is to change the field type from "Text" to "Calculation".
Thank you that worked!!
and not stored, since the current date is a value used.
Retrieving data ...