Forum Discussion
JacobJacob
8 years agoQrew Cadet
How about just making table B a connected table and filter only the records where the effective date is on or after today. You could then set it to refresh every hour. Then only the records that have an effective date past today will pull into that table. There are cons to using a connected table but this seems simpler than managing four tables.
RichardPfister
8 years agoQrew Cadet
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?