between "dateA" and "dateB" not returning values 1

[jeffmorl]

OK. I've been using "between "dateA" and "dateB" for a while now and have a situation where the records with dateB don't appear in the query results.

Here is the sql code I'm using;

SELECT T_DMZ_EQUIPMENT.ITEM, T_DMZ_EQUIPMENT.TRANS_DATE
FROM T_DMZ_EQUIPMENT
WHERE (((T_DMZ_EQUIPMENT.TRANS_DATE) Between #2/6/2012# And #2/9/2012#))
ORDER BY T_DMZ_EQUIPMENT.ITEM, T_DMZ_EQUIPMENT.TRANS_DATE;

I would think that the results would include all dates between 2/6/12 and 2/9/12 inclusive... The result gives the date range with the exception of 2/9/12.

What am I missing here?
Thanks in advance.

 

[PHV]

Does TRANS_DATE contain time value ?
You may try this:
SELECT ITEM, TRANS_DATE
FROM T_DMZ_EQUIPMENT
WHERE TRANS_DATE Between #2012-02-06 00:00:00# And #2012-02-09 23:59:59#
ORDER BY ITEM, TRANS_DATE

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jeffmorl]

Thanks PVH, it does have a time value.

I guess I've never had the need to include a time value, but this time I do.

 

[jeffmorl]

So now the question is, How to get the user to enter the time parameter from a date picker.

 

[PHV]

From which time parameter are you talking about ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jeffmorl]

Nevermind. I figured it out.

Thanks for the clue about the TransDate having a time value to it.