By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,307 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,307 IT Pros & Developers. It's quick & easy.

parameter query pulling wrong data

P: 14
Hi all,

I am running a query to pull up dates between a certain period start (10/1/07) and end(10/31/07) but the results include dates dates within the october month but different year i.e. 10/3/06, 10/21/05 . Help!!!
Oct 4 '08 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Carnac the Magnificent no longer comes to this forum! Obviously you're only pulling the month/day portion of your dates, but we'll need to see the SQL code you're using before we can tell you what's wrong with it!

Linq ;0)>
Oct 4 '08 #2

P: 14
Hi Linq,

Thank you for replying. I figure it out. the wrong dates were pulled up because in the underlying table, the date field was a text data type and I changed it to a date data type. I am now getting the right results. I am working on a database that was created by someone else.

Thanks again for your help
Oct 4 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
Glad you got it working!

Linq ;0)>
Oct 5 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.