473,746 Members | 2,670 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DateTimePicker Date Format Weirdness

I have a DateTimePicker control on my form that is displaying the date
format in UK format (dd/mm/yy).

However, in my code dtpStartDate.Va lue gives a date in US format, but
dtpStartDate.Va lue.ToString() gives the date in the required UK format!

Any ideas? All system locale settings are set to British/UK settings.
Nov 15 '05 #1
9 5043
Ed Crowley <cu******@pacbe ll.net> wrote:
I have a DateTimePicker control on my form that is displaying the date
format in UK format (dd/mm/yy).

However, in my code dtpStartDate.Va lue gives a date in US format, but
dtpStartDate.Va lue.ToString() gives the date in the required UK format!

Any ideas? All system locale settings are set to British/UK settings.


DateTimePicker. Value isn't in *any* particular format - it's just a
DateTime. What do you mean by "gives a date in US format"?

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Nov 15 '05 #2

"Jon Skeet [C# MVP]" <sk***@pobox.co m> wrote in message
news:MP******** *************** *@msnews.micros oft.com...
Ed Crowley <cu******@pacbe ll.net> wrote:
I have a DateTimePicker control on my form that is displaying the date
format in UK format (dd/mm/yy).

However, in my code dtpStartDate.Va lue gives a date in US format, but
dtpStartDate.Va lue.ToString() gives the date in the required UK format!

Any ideas? All system locale settings are set to British/UK settings.


DateTimePicker. Value isn't in *any* particular format - it's just a
DateTime. What do you mean by "gives a date in US format"?


When I assign the value of the DateTimePicker to a DateTime variable, it is
in US format (dd/mm/yy) when I step through the code. When I then try and
pass this date as a parameter to a SQL Server stored procedure it falls over
as the date is invalid (for example today is 11/25/2003 which isn't a valid
UK date, but 11/11/2003 works fine).
Nov 15 '05 #3
My guess is that Visual Studio's internal workings are showing through,
and Visual Studio follows US formats, not international or standard ones..
(For instance week enumeration starts with sunday, despite that standards
clearly state monday to be first day of a week)

Are you getting US formats when outputting result somewhere, or only while
debugging?
As mentioned by Jon, Value returns a DateTime object which can be any
format but itself should be local independent.
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 15 '05 #4
I don't think you can change the way the DateTime object stores it's date
which is as mm/dd/yyyy
I'm not sure how SQL accepts a datetime object, but you may have to change
the sql procedure to perceive that datetime object as mm/dd/yyyy or pass
it something other than a DateTime object. I could be wrong.

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 15 '05 #5
Ed Crowley <cu******@pacbe ll.net> wrote:
DateTimePicker. Value isn't in *any* particular format - it's just a
DateTime. What do you mean by "gives a date in US format"?
When I assign the value of the DateTimePicker to a DateTime variable, it is
in US format (dd/mm/yy) when I step through the code.


That's just how the debugger happens to show it, I suspect. DateTimes
themselves have no intrinsic format.
When I then try and
pass this date as a parameter to a SQL Server stored procedure it falls over
as the date is invalid (for example today is 11/25/2003 which isn't a valid
UK date, but 11/11/2003 works fine).


How are you passing the date? If you specify it as a DateTime rather
than converting it into a string in the first place, it should be fine.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Nov 15 '05 #6
Morten Wennevik <Mo************ @hotmail.com> wrote:
I don't think you can change the way the DateTime object stores it's date
which is as mm/dd/yyyy


No, DateTime stores it as a long.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Nov 15 '05 #7
On Tue, 25 Nov 2003 12:57:07 +0100, Morten Wennevik <Mo************ @hotmail.com>
wrote:
My guess is that Visual Studio's internal workings are showing through,
and Visual Studio follows US formats, not international or standard ones.
(For instance week enumeration starts with sunday, despite that standards
clearly state monday to be first day of a week)


Yes. This can be changed by updating the culture.FirstDa yOfWeek, but even then,
the built-in DateTimePicker and MonthCalendar do not respect the settings of the
current culture. Go figure.

Nov 15 '05 #8
On Tue, 25 Nov 2003 11:43:15 -0000, "Ed Crowley" <cu******@pacbe ll.net> wrote:
When I assign the value of the DateTimePicker to a DateTime variable, it is
in US format (dd/mm/yy) when I step through the code. When I then try and

U.S. format is mm/dd/yy

Nov 15 '05 #9

"Kerry Sanders" <di****@NOSPAMy ahoo.com> wrote in message
news:i7******** *************** *********@4ax.c om...
On Tue, 25 Nov 2003 11:43:15 -0000, "Ed Crowley" <cu******@pacbe ll.net> wrote:
When I assign the value of the DateTimePicker to a DateTime variable, it isin US format (dd/mm/yy) when I step through the code. When I then try
and

U.S. format is mm/dd/yy


I know ... it was a typo!
Nov 15 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1402
by: E-Cube | last post by:
Hello All, I have a datetimepicker whose initial format is: DateTimePicker1.Format = DateTimePickerFormat.Custom DateTimePicker1.CustomFormat = " " DateTimePicker1.Checked = False which will change to DateTimePicker1.Format = DateTimePickerFormat.Short
9
3974
by: Guy | last post by:
I have extended the datetimepicker control to incorporate a ReadOnly property. I have used the new keyword to implement my own version of the value property, so that if readonly == true then it will not set the value of the control and will leave the checked status of the checkbox to false when a user selects a new date. this works fine when using the control on a win2k machine but if we use it on a win XP box and call
7
8496
by: Edward Mitchell | last post by:
I have a number of DateTimePicker controls, some set to dates, some set to a format of Time. The controls are all embedded in dialogs. I created the controls by dragging the DateTime picker from the Toolbox and then set the Format property appropriately. I have noticed that sometimes the Time format will reset spontaneously to Short Date. I looked at the .rc file and found that the usual form for a Short Date is as follows: CONTROL ...
2
3386
by: Chris Fairman | last post by:
NG, Maybe I'm missing a key step, but it seems when typing dates into a DateTimePicker control (format = 'Short'), the controls' .text property is not updated until the control losses focus. I'm handling an <enter> key event on a DateTimePicker control. Essentially I want to give a user the ability to type a date in the DTP, and press <enter> and have a DataGrid populate with user supplied data from the DTP control.
2
8195
by: Claes Wedin | last post by:
My customer needs a DateTimePicker in VS2005 C# that can show emty date values (blank/space/null). I need a control that: 1. Can show a blank value 2. Detete a date when hitting the delete and/or back key 3. Allowse the user to enter yyyy-MM-dd date format manually 4. When tabbed into the field behaves juast like a textbox
5
7678
by: Terry | last post by:
My system short date format is dd/mm/yy. The DateTimePicker returns mm/dd/yyyy hh:mm:ss PM. I need to get this value formated into dd/mm/yyyy regardless of the system short date format, what do I need to use please. Regards Terry
0
2600
by: tschroeder250 | last post by:
Hi Everyone, There are so many Nullable DateTimePickers out there that this post may not even be found among all the others, but I wanted to try. First, I want to thank all the authors of the code I used as a starting point. Second, I hope this code helps someone as much as they helped me. I have built a Nullable DateTimePicker and NullableCalendarColumn/Cell/EditingControl that is nearly 100% complete, as far as I can tell. There is...
11
5018
by: jessy | last post by:
Hi, I have a problem with my DateTimePicker javascript code which i downloaded , the problem is when i pick the date and the date appears in my Text Field and i click Submit the date which i picked is not sent to the DB and instead the default value of the text field which is 00-00-0000 is Sent so what i need is to make the value i picked replace the value of the Text Field and i cant seem to get the Js code which i downloaded . i'm...
0
5656
by: priyamtheone | last post by:
I'm trying to make a datagridview column to act like a datetimepicker column (C#.Net 2005). These are the behaviours that the dgv should have: 1) Initially all the cells of the dtp column should be blank unless they are filled by the user. 2) As soon as the user enters a cell, the dtp control should appear as the editing control of that cell. If there's a value in the cell beforehand, that value is set as the value of the dtp editing control...
0
8974
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8800
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9508
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8229
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6772
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6060
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4836
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2765
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2199
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.