?
Solved

Datetimepicker Dates and SQL Server Format

Posted on 2006-07-19
1
Medium Priority
?
428 Views
Last Modified: 2012-08-14
Hi,

I have a VB application form with two datetimepickers, Datagrid and Button. The user is to select a start date and end date using the datetimepickers. Once selected,  on click of the button a query is sent to the SQL server database table to return entries between these dates and populate the Datagrid with results.

If I select between dates 05/07/2006 and 07/07/2006 - I also get entries starting from 25/05/2006.

There seems to be a problem between dd(days) and MM(months) using dd as MM.

I have the DateTimePickers format set to Custom and CustomFormat as dd/MM/yyyy

Entries in the table being query also follow this format dd/mm/yyyy.

Can anyone tell me what is happening here, I only want entries from the selected dates.

Here is my SQL Command

SELECT * WHERE MdnMaster.ActualDeliveryDate BETWEEN '" & DTP_StartDate.Value & "' AND '" & DTP_EndDate.Value & "'", cn)

 
0
Comment
Question by:daly__paul
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 34

Accepted Solution

by:
Sancler earned 1500 total points
ID: 17139032
.Value is still in MM/dd/yyyy format.  What your custom formatting does is alter what is displayed into dd/MM/yyyy format.  The easiest way is to use DTP_StartDate.Text and DTP_EndDate.Text in your Select command.

Roger
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question