Variable in ACS SQL

["gio.cot" <gio.cot@xxxxxxxxxxx>]

Hi all 

Suppose i have this Sql statement :

 

select * from mytable where mydate between 20230101 and 20230430 

is it possibile define some variables (in ACS Script Sql)  and substite the
date with the variable defined ?

example

 

set date01 = 20230101

set date02 = 20230430

select * from mytable where mydate between date01 and date02

 

Thanks in advance