Today's date query

[Darkarr]

Im sure this is an easy question. Im running a query that will show all orders due on todays date. The =date() command does not work. Any thoughts on what I am doing wrong? Using 2002

Thanks,

Darren

 

[starsky51]

Darkarr,

The Now() function returns the exact current time and date. To retreive just today's date you can use:
Format(Now(),"dd/mm/yy&quot
You can play about with the "dd/mm/yy" bit to get different layouts of dates.

starsky51