Set the default value of date type Variable to current date or today's date

@Kunal @dnewc @EhubMcCoy @JasonAltenburg @BryantCafferty take a look at this tutorial video:

Very cool, @ellibot! Trouble for me is I don't have access to Workflows in my instance. Hopefully @Matt Tannyhill will have good news for us soon on a native solution within the core product soon! 🙏

When using a date variable, a new default value 'Today's Date' should be an option. It should take the date of the current timezone of your instance.

This seemingly simple update would be powerful for my team. Right now, any dashboard using a variable is then not able to be turned into a scheduled report because the date variable would always need to be updated before the report goes out.

Bonus: Allow for a calculation like subdate(currentdate(),interval 1 day) to set the default to yesterday.

Specifically, having the ability to set the default value of a variable to a dynamic value such as current_date(), instead of having to choose one static date.