interesting post, thanks.
have you tried using today as a reference frame and calculating what you want based on that?
What I mean is to start with Get(CurrentDate) and then define your time period based on that...something like:
Enter Find Mode
SetField [Table1::field1;(Get(CurrentDate)-8) & "..." & (Get(CurrentDate)-1)]
This is just a thought, I haven't tried this myself...but it's what came to mind as a potential approach. What do you think?
Thanks for your suggestion!
I'll try it and post feedback.
I'll refine my post and publish it again; I didn't get this to work.