Click here to Skip to main content
11,481,838 members (61,253 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: Access VB.NET
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 28-Mar-13 0:54am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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. Smile | :)

If there is time part, use date1.Date to enter date part only.
Rachna0309 at 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)

Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 28 Mar 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100