DateTimePicker Date Formatting

Question

0.00/5 (No votes)

See more:

I am trying to format my datetimepicker to MM/dd/yyyy only with no time of day parameter.
I set the custom format to MM/dd/yyyy and set format to custom in the Properties Explorerdw, but when it writes the format to a datagridview, it's "MM/dd/yyyy hh:mm:ss tt".
I have my variable declared as follows... Could the .TEXT be the issue?

VB

Dim datepicked As Date
datepicked = DateTimePicker1.Text
'add column with datepicked
DataGridView1.Columns.Add(AddCol4)
For Each dgvr As DataGridViewRow In DataGridView1.Rows
    dgvr.Cells("Date").Value = datepicked
Next

Posted 22-Jan-14 4:16am

moordoom

Add a Solution

2 solutions

Solution 2

So by doing this it should work? ...

VB

Dim datepicked As Date
datepicked = DateTimePicker1.Text

Dim AddCol4 As New DataGridViewTextBoxColumn
AddCol4.DataPropertyName = "Date"
AddCol4.HeaderText = "Date"
AddCol4.Name = "Date"
AddCol4.DefaultCellStyle.Format = "MM/dd/yyyy" 'Adding this

DataGridView1.Columns.Add(AddCol4)
For Each dgvr As DataGridViewRow In DataGridView1.Rows
    dgvr.Cells("Date").Value = datepicked
Next

And it does.
Thanks, you are a gentleman and a a scholar :)

Posted 22-Jan-14 4:39am

moordoom

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ron Beyer · Accepted Answer · 2014-01-22T04:22:00

Even though they don't show the time, DateTimePicker always picks a DateTime, and DateTime always includes a time.

So datepicked, being a DateTime will always have a time element, no matter what you do. If you want it to only display as a date in your column you should set the DefaultCellStyle.Format to your Date/Time format string "MM/dd/yyyy".

See http://msdn.microsoft.com/en-us/library/vstudio/f9x2790s(v=vs.100).aspx[^] for more information on setting your cell format.