Click here to Skip to main content
15,867,879 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have query in ms access where I need to compare date...My database field I need to compare is TRDATE(datatype is datetime and format is SHort Date)..When I run the below query in development PC which is 32-bit,it gives me records..

"Select * from NTRANS1213 where(NTRANS1213.TRDATE BETWEEN #3/26/2013# AND #3/26/2013#)"

Both dates are taken from datetimepicker in software.



The same query when I run in 64-bit PC from query analyser of Office 2007,I get records..

But If I run application,no records are retrived even though there are 2 records between these dates.
I am not able to figure out the problem.Please help me...
Posted

1 solution

Check you database for the columns containing the dates. Probably date may contain time part also there by negating the filter condition. Happens all the time. :-)

If there is time part, use date1.Date to enter date part only.
 
Share this answer
 
Comments
Rachna0309 29-Mar-13 0:12am    
No it does not contain time...It has only date...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900