Help! Query which date as a criteria

D

Danny

Hi all

I want to make a query to show the transaction of today. But the date data is full date and time in the table. I use the condition date=Date() but there is no shown in the query. Please Help
 
N

Niklas Östrergren

Hi Danny!

Have you tryed with NOW()?

// Niklas


Danny said:
Hi all,

I want to make a query to show the transaction of today. But the date data
Click to expand...
is full date and time in the table. I use the condition date=Date() but
there is no shown in the query. Please Help
 
Top