WHERE datefield > Yesterday() ???
WHERE datefield > Yesterday() ???
(OP)
This is about SQL Anywhere 11 - with Visual Studio 2008 - via ODBC
I try to create a query with filter to a datefield (LAST_CHANGED) > Yesterday.
As from MSSQL I know "Today()-1" --- this does not work here. I also tried "> Dateadd (day, -1, Today())" - Invalid expression
Does anybody have a hint for me, how to do that correctly?
Thank you in advance!
Mirko
I try to create a query with filter to a datefield (LAST_CHANGED) > Yesterday.
As from MSSQL I know "Today()-1" --- this does not work here. I also tried "> Dateadd (day, -1, Today())" - Invalid expression
Does anybody have a hint for me, how to do that correctly?
Thank you in advance!
Mirko
Kind regards
Mirko
--------------------------------------
>>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<
RE: WHERE datefield > Yesterday() ???
RE: WHERE datefield > Yesterday() ???
But anyway - I just remembered, I did an export for Sybase SQLAnywhere years ago with VB6 - so I looked up the sourcecode and decided to do it with VB6. Works like a charm ...
So this case may be closed.
Kind regards
Mirko
--------------------------------------
>>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<