Click here to Skip to main content
11,931,104 members (60,364 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB 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 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.151126.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