Can I use constants in my sql derived table?

Hi all, 

I’d like to work with constants in my manifest file however I can’t seem to get it to work. Am I able to use constant in my sql derived table? 

My manifest file: 

constant: some_date {

    value: “2022-06-10” 

} 

I want this constant so I can use it across different views. 

my sql derived table: 
sql: some_query from some_table WHERE date = @{some_date}

… I’ve also tried in quotes:

WHERE date = “@{some_date}” 

But this isn’t working. I am getting an error of: “2022-06-10” does not exist in some_table. Any one know what;’s going on?