Getting data from Yesterday?

[Chavito21]

I have a query and I want to tell it to get the information from yesterday. How can I tell it to do date() -1 so I can get yesterday data?

 

[KenReay]

Hi

put DataAdd("d",-1,date()) in the criteria

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Chavito21]

It give me this error mesg:
Syntax error (comma in query expression '(((ORDERS.[Date Added])=("d",-1,Date())))'

 

[KenReay]

Hi

(((ORDERS.[Date Added])=("d",-1,Date())))'

is not what I said

if this is in an SQL string in code yoe need:

... Orders.WhatEverYourDateColIs = #" & DateAdd("d",-1,date()) & "# ...etc"

if you are not in USA you need to convert the date to US or ANSI format using FORMAT()

... Orders.WhatEverYourDateColIs = #" & Format(DateAdd("d",-1,date()),"yyyy/mm/dd") & "# ...etc"


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Chavito21]

Okay I got it, I have a field named Date Added but when I enter on criteria I didn't put the dateAdd which it need to be there. sorry. It's working great thanks for the help.

Chavito