Set DateTimePicker Control to format YYYYMMDD?

Question

I am putting together a simple C# Windows Forms Application. I am setting my DateTimePicker control on load to the current DateTime, example "11/12/2013 9:49:49 AM". I then use this value in a query to my 400 system, but I am getting an error because the field I query against the DateTimePicker Controls value is in format 'YYYYMMDD'.

How do I format the value of my DateTimePicker Control to 'YYYYMMDD' to use it in my query?

Solution 1

Actually, if your control is named dtpDate, you should use something like this (using the Value property of the control):

string selectDateAsString = dtpDate.Value.ToString("yyyyMMdd");

Solution 2

You can easily format the datetime into a string like the one you want:

 the_date_time.ToString("yyyyMMdd");

Solution 3

you need to get the DateTime value from the date time picker then do tostring() on that with the format.

string formateddate = dtpDate.Value.ToString("yyyyMMdd");

Solution 4

Post format your date:

string formattedDate = MyDateTime.ToString("yyyyMMdd")

if directly from the DateTimePicker control use:

string formattedDate = MyDateTime.Value.ToString("yyyyMMdd")

View more solutions

Comments

[Analytic Lunatic]

When I try string formattedDate = dtpDate.ToString("yyyyMMdd"); I receive: "No overload for method 'ToSTring' takes 1 arguments".

[DROP TABLE users]

@AnalyticLunatic you need to get the DateTime value from the date time picker then do tostring() on that.

[Analytic Lunatic]

When I try string formattedDate = dtpDate.ToString("yyyyMMdd"); I receive: "No overload for method 'ToSTring' takes 1 arguments".

[Analytic Lunatic]

When I try string formattedDate = dtpDate.ToString("yyyyMMdd"); I receive: "No overload for method 'ToSTring' takes 1 arguments".

[Analytic Lunatic]

@DROPtableusers, string formattedDate = dtpDate.Value.ToString("yyyyMMdd"); did it! Thanks!

[DROP TABLE users]

@AnalyticLunatic glad you got it. I edited my answer to reflect below.