WHERE datefield > Yesterday() ???

[kermit01de]

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

Kind regards
Mirko
--------------------------------------
>>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<

 

[yelworcm]

I'm not familiar with any function in MSSQL called "Today()". Have you tried getdate()?

 

[kermit01de]

Sorry, should be "Now()"

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 ... <<<<<