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...