I would recommend that you consider having an extra date field that is relative to today. You can call it DaysAgo.
0 is always today. 1 would be yesterday .... and so forth.
The beauty of this is that as long as you fix DaysAgo to be 0 it will always be current. You could of course create additional xxxxAgo fields for Months, Quarters, Weeks and Years too if you need.
This would make your problem disappear as you don't need to dynamically update your selections.
Sorry i have not replied sooner but i have been poorly
I am afraid i do not understand the concept behind xxxago field.
When my new data comes in say 1/05/2018 i can fix this so it is 0 daysago so my selection can open with the latest data - but how do my users chose to see the previous set of data?