"Yesterday" in an expression

[Whodini]

What date expression would I use to create a SQL query to search a table from "Yesterday"?

 

[mp9]

Something like:

SELECT MyDateField
FROM MyTable
WHERE MyDateField=Date()-1;

Hope this is helpful.

http://www22.brinkster.com/accessory/

 

[Whodini]

mp9,

Thank you for your quick response.

I am still having problems.

I tried your suggestion in the following expression:

STOREMST.STORE NOT IN (Select storenum from XBR_STORE where transdate = date()-1; and XBR_STORE.AS_SALES_CT <> 0)

I get an error: 'Date' is not a recognized function name.

What could I be doing wrong?

 

[mp9]

Is this in the Expresseion Builder or in the SQL view of a query?

http://www22.brinkster.com/accessory/

 

[PHV]

What about this ?
where CLng(transdate) = CLng(Now())-1 and XBR_STORE.AS_SALES_CT <> 0

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244