Query for todays date 1

[slammer14]

I want to do a query for the current date. I want to show all the records for that day.

But not sure how, criteria=Date() does not seem to work

THanks slammer

 

[PaulBricker]

I assume on your Criteria line you put =Date() and not Criteria = Date().
What is the format for you field? Is it mm/dd/yy or similar or does it contain the time as well? If your date field contains Time as well, you will not be able to Date() as the criteria. You would need to add a field to the query
MyNewDateField:Format([YourDateField],"mm/dd/yy&quot and then on the criteria line for this field put
=Date()

 

[slammer14]

OK, the input mask is short date. However the datatype is date/tiem. I am still not sure.

Right now it prints all the invoices.

Thanks for answering quickly

slammer

 

[PaulBricker]

Datatype date/time is fine and the Short Date is fine. On the criteria line for your query you should put
=Date()

that's all it should take to return any records with todays date in them.

Paul

 

[NBAbueg]

Slammer,

Did you try =Now() ?