Query criteria help

**balderman** · 04-05-2018, 08:30 AM

I need help please. I want the query to show records that are 3 days or more past the completed date. I can't seem to figure out how to get it to work. I googled it and tried many different things and nothing is working. Please let me know what I am doing wrong. Screenshot below.

Click image for larger version.

Name: screenshot.jpg
Views: 16
Size: 163.0 KB
ID: 33418

**isladogs** · 04-05-2018, 08:49 AM

Use <Date-3 as the criteria for completed date field

**balderman** · 04-05-2018, 08:51 AM

OK but shouldn't it be + and not - since I want to show 3 days or more AFTER the completed date?

**balderman** · 04-05-2018, 08:53 AM

When I put that in it says "Data type mismatch in criteria expression"

**isladogs** · 04-05-2018, 09:05 AM

Originally Posted by balderman

OK but shouldn't it be + and not - since I want to show 3 days or more AFTER the completed date?

Originally Posted by balderman

When I put that in it says "Data type mismatch in criteria expression"

The idea is to check where completed date is more than three days ago
Forgot the brackets. It should have been

Code:

<Date()-3

**balderman** · 04-05-2018, 09:27 AM

Ok I understand now. I was thinking of it the wrong way. Thanks so much for your help, it worked!

Query criteria help

Thread Tools

Query criteria help

Similar Threads

Query Date Criteria, using multiple column data within one criteria

Query criteria expression builder for criteria from a form

Query where it only shows those with specific criteria in a cell (that criteria is being blank)

Combining Two criteria to Form StrCrteria to be used as a criteria in query

Multi Select List Box selecting Query Criteria, Criteria come up with quotation marks

Posting Permissions