Click here to Skip to main content
11,577,710 members (61,794 online)
Rate this: bad
good
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 27-Mar-13 23:54pm

1 solution

Rate this: bad
good
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.
  Permalink  
Comments
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)

  Print Answers RSS
0 Peter Leow 180
1 Richard MacCutchan 175
2 DamithSL 150
3 OriginalGriff 135
4 Afzaal Ahmad Zeeshan 95
0 OriginalGriff 830
1 Sergey Alexandrovich Kryukov 701
2 Abhinav S 573
3 F-ES Sitecore 420
4 Dave Kreskowiak 374


Advertise | Privacy | Mobile
Web03 | 2.8.150603.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