Managing Value List Members via the Current Date

[RecessionProof]

I'd like to build a value list that is based on fields containing dates. If the date in the field is a date in the future I want it in my value list. If the date is in the past I do not want it in my value list.

What are the possible solutions?

[mr_vodka]

create a new unstored calc with Get(CurrentDate)

Create a new relationship keyed from this new calc field to your date field that you want. Instead of using " = ", use " ≤ " instead.

cCurrentDate ≤ YourDateField

Now you can refer to this relationship for your value list.