WHERE datefield > Yesterday() ???

kermit01de · Feb 17, 2014

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 · Feb 21, 2014

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

kermit01de · Feb 21, 2014

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

WHERE datefield > Yesterday() ???

kermit01de

Technical User

yelworcm

MIS

kermit01de

Technical User

Similar threads

Part and Inventory Search

Sponsor

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

WHERE datefield &gt; Yesterday() ???

kermit01de

Technical User

yelworcm

MIS

kermit01de

Technical User

Similar threads

Log in

Part and Inventory Search

Sponsor

WHERE datefield > Yesterday() ???