Custom SQL Statement not working anymore 追蹤
I have the following SQL Statement which selects records out of an Excel-File. I use the function NOW() in order to get the current date. The statement worked fine in Bartender 10.0, but after we upgraded to Version 2021, I get the following error: Error:  Could not execute the specified command: Unknown function: NOW
Here's the statement:
SELECT * FROM `Sheet1$` WHERE `NOM` IS NOT NULL AND `MG MAT` IS NOT NULL AND `DEBUT` > NOW() AND `FIN` > NOW()+5 AND `FIN` <= NOW()+13
Maybe anyone in here has got an idea how I can fix this problem?