Multiple criteria on DCount including date field

[June7]

The date formatting includes # delimiters so it should work.
Semicolons instead of comma is syntax I see in many non-U.S. Access dbs.

 

[Eugene-LS]

=DCount("*";"tblJobRefBook";"JobStatus = 'Quoted' AND QuotedDate < Date()"

Harsh practice:

 

[PaulD2019]

@PaulD2019 while likes are appreciated, this is not a social media site where people are trolling for "likes". We are answering technical questions. "Liking" every single response is not useful. People who find this thread in a search have no way of determining which thing you "liked" worked or if you were just being polite and thanking people for bothering to offer a solution. If a specific solution solves your problem, mention that specifically so that the actual solution is clear.

Apologies @Pat Hartman , Noted

Thanks for your help, neither of the below work in the listed format

=DCount("StatusName";"tblJobRefBook";"JobStatus = 'Quoted' AND QuotedDate < Date()" ----would have worked although it is inefficient compared to
=DCount("*";"tblJobRefBook";"JobStatus = 'Quoted' AND QuotedDate < Date()"

even after changing the semicolons to commas, after changing to commas both said they needed a closing bracket, I assumed they need to be added at the end, I added the bracket at the end & got the below results

=DCount("StatusName","tblJobRefBook","JobStatus = 'Quoted' AND QuotedDate < Date()")
This displays 571 instead of 565 as it should or 531 as what has been posted above, I can't see where the 571 came from either.

=DCount("*";"tblJobRefBook";"JobStatus = 'Quoted' AND QuotedDate < Date()"
This displays #Error with the field flashing

Thanks again all for your help

 

[Eugene-LS]

=DCount("*";"tblJobRefBook";"JobStatus = 'Quoted' AND QuotedDate < Date() - 30") ... -would have worked

Yes, you are absolutely right!

 

[cheekybuddha]

The third argument of the function DCount() "WhereCondition" is a string!

It is a string that needs to represent a valid WHERE clause. In SQL the WHERE clause can use the Date() function directly.