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
Solved

Datetimepicker Dates and SQL Server Format

Posted on 2006-07-19
1
424 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
1 Comment
 
LVL 34

Accepted Solution

by:
Sancler earned 500 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

861 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