I just got this all setup for a Cabin were renting.
Let me know what you think. You can set the "Today" GV as a local variable instead and then use the 1st line of the rule to populate the date into the local variable.
If you need help setting this up let me know. Also the date has to be in the format shown on my dashboard to work.
Here are the screenshots of the Dashboards, Global variables, and Rules
