Date functions for reports

[slames]

I want to be able to produce a report listing all items sent out today. The field I am referring to is a datetime field. When I add =date() to the criteria of the sql for the record source, it comes up the the error unrecognised function, and if I use the now() function it pulls through nothing as it tries to match the time now too. How can I use sql to pull out items sent out today and therefore only equal the date half of this field. If I add > 08/04/2003 00:00 this works but I want to be able to just print off the report every day without having to change the date each time.
Any help gratefully received.
Thanks
Steph

 

[CosmoKramer]

Try this as your criteria:

Between Date() & " 00:01" And Date() & " 23:59"

 

[slames]

This still generates an error:
Your entry cannot be converted to a valid datetime value.

Any ideas what could be causing this?

Thanks
Steph

 

[CosmoKramer]

Is this truly a datetime field, and if so, what is its format??

 

[slames]

the format is dd/mm/yyyy 00:00

 

[CosmoKramer]

Take a look at your system's date settings under Regional options. It appears there is a conflict between your PC and what you have defined in your database....