Custom SQL Statement not working anymore 追蹤

0
Avatar
Luc Hagen

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: [500] 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?

 

 

登入寫評論。