Hi @MarkD ,
You may use 

set variable_name.var= '1900-01-01'

to set the value of variable and in order to use the value of variable 
use 

${automated_date.var}

Example:

set automated_date.var= '1800-01-01'
select * from my table where date = CAST(${automated_date.var} as DATE)