Filter Linked Excel File base off Date
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?
0
サインインしてコメントを残してください。
コメント
0件のコメント