I'm trying to build the connected table to handle this problem and I don't see a way to filter the connected fields using a dynamic date. I can set it for "Now" but that doesn't update as time progresses. The date field in the connection filter does not allow any typing, just date selection. I want to create a connection that connects records whose effective date is <= the current point in time (i.e. via formula), essentially connecting fields to the new table when they become effective. Any ideas on how to make this happen?
