Only Show Last 7 Days of data

[MFS]

Hello all,
I'm trying to have my query show only the last 7 days worth of data.
Any help?
I've tried Between Now() and Now()-7 But not working



Mike

[Jester0001]

Where did you put the "BETWEEN Now() AND Now()-7"? When I put it in the criteria of the date field of my query, it works great by only showing data from the last week.

[MFS]

I'm entering it into the Criteria of my "Today" Field. Maybe it's do to another expression I have in another field. Attached is a copy of my query.
This query is provideing a graph with equipment downtime data and I'm wanting it to show all downtime for the past 7 days.

[mejia.j88]

under criteria of your date field in query:

>= date() - 7

[MFS]

>= date() - 7
Sorry,

Doesn't work either. I believe it is do to my expression in expr1: that is causing my problem??? Just not sure why.

[mejia.j88]

you are placing this under [today]?
does the query run well with no criterias in place?

[MFS]

Yes the query runs perfect but shows years worth of data on the graph.
Yes, putting under [today]

[mejia.j88]

what error does it give you, or does it return an empty query?

[MFS]

It would reply an empty Query, good news I finally got it to work using "Between Now() And Now()-7". Not sure why it works now and not all the multiple tries prior. Thank all of you though for your support.