Date without time

[stenman]

Hello,


I am looking for solution how to display date in a query. In my table I have field as Date\Time but I would like to leave out time in my query as:
=#01.09.2013# this is giving me a "blank answer" so question is how to define that it should ignore the time in the field. Because if I enter:
=#01.09.2013 13:00:00# one record is shown since the record is matching. How to define date without having to enter time as well, or is it not possible when choosing data type Date/Time?
Many thanks in advance for your help.
Br
Anders

I found solution in following post:
https://www.accessforums.net/reports...eld-17595.html

[June7]

Be aware that Format results in a string value, not a date. Depending on what you do with the value, might have to convert back to a date. Sometimes delimiting with # is sufficient, if not try wrapping in CDate() function.