I'm trying to create a filter based off todays date:

------------

SELECT DISTINCT `CurrentDate`, `Base36Value` FROM `Sheet1$` ORDER BY `CurrentDate` , `Base36Value` , WHERE 'CurrentDate'= 1/1/2024

------------

I want to add, WHERE CurrentDate = today

I keep on getting:

Error: Syntax error (missing operator) in query expression 'WHERE 'CurrentDate'= 1/1/2024'.

Hope someone can help?