I am using a datetimepicker and only need the date not the date time. How can I just get the date (mm/dd/yyyy) without time (hh:mm:ss) I have set in the format property custom and set the customformat to mm/dd/yyyy -- it still insists to pass mm/dd/yyyy hh:mm:ss to my variable.

DateTime StartDate = this.dtpStartDate.Value

the StartDate needs to be datetime datatype because that is what the parameter is in my stored procedure that it is populating.

The problem is when the stored procedure is executed within sql server with date range of 9/1/2013 to 9/30/2013 it pulls data for that date range. When i use the datetime from the datetimepicker in my code the stored procedure pulls data for 10/1 as well.

I used this.dtpStartDate.Value.Date and that did the trick. Thanks.