Go to Sheet Properties and add a Trigger to OnLeaveSheet. For the Trigger, you need External>Set Variable. Then add the Variable Name and for Value, =Only(Date).
I've attached a quick sample. In my sample, I use Customer instead of Date. The Trigger is when leaving Main.
Since you're using Only, there needs to be one and only one value selected in Date. If nothing is selected or more than one value is selected, it will probably set the variable to null.