Click here to Skip to main content
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 28-Mar-13 0:54am

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 Kornfeld Eliyahu Peter 169
1 Zoltán Zörgő 139
2 George Jonsson 135
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 28 Mar 2013
Copyright © CodeProject, 1999-2014
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