[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Datetimepicker Dates and SQL Server Format

Posted on 2006-07-19
1
Medium Priority
?
429 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

649 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