Extracting date from dat/time field : help required

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

skinnybloke - 31 Jan 2006 12:34 GMT

Hi - I have a date field in a Access database in the format
YYYY/MM/DD HH:MM

I have set up 2 date parameters as below but only want to enter the
date and not the time. If I do not enter the time no records are
returned.

SELECT * FROM tables WHERE Order.[Date Received] Between [Enter Start
Date] And [Enter End Date];

Is there a simple way of doing this?

Reply to this Message

Allen Browne - 31 Jan 2006 15:58 GMT

Ask for less than the next day:

SELECT * FROM tables
WHERE (Order.[Date Received] >= [Enter Start Date])
AND (Order.[Date Received] < [Enter End Date] + 1);

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi - I have a date field in a Access database in the format
> YYYY/MM/DD HH:MM
[quoted text clipped - 7 lines]
>
> Is there a simple way of doing this?

Reply to this Message