converting string to datetime issue

Question

I have been looking around the web to find an example that will solve my issue with string convertion to datetime.

I would like to convert en-us (mm/dd/yyyy) to dutch belgium (dd/mm/yyyy) datetime. Could you please give me a working example?

For your information, I have tried Convert.ToDateTime, Parse, TryParse, ParseExact etc, but none was working. I really like an example that will make this conversion, no futile links.

Upate

The error I get is: String was not recognized as a valid DateTime. What I have tried:

----------------
string str = "02/20/2012";
DateTime dt = Convert.ToDateTime(str);
---------------------
IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("nl-BE", true);
DateTime theDateTime = DateTime.ParseExact(deliveryDate, "dd/mm/yyyy", theCultureInfo);
Console.WriteLine(dt);
----------------------
var parsed = DateTime.ParseExact("02/20/2012","dd/mm/yyyy", null);
---------------

dateValue = DateTime.Parse(dateString, new CultureInfo("nl-BE", false));

and some other examples which I don't remember them now. But all leading no where.

DateTime should support a CultureInfo. See: stackoverflow.com/questions/313781/… — Brandon
– Brandon, Commented Aug 17, 2012 at 18:24
@Henk Could you please give me a working example, not just suggestions because I have seen a lot and I could not get it work. — Imir Hoxha
– Imir Hoxha, Commented Aug 17, 2012 at 18:59

stakx - no longer contributing · Accepted Answer · 2012-08-17 19:00:35Z

9

Use these method overloads:

and pass a CultureInfo.DateTimeFormat to them:

string enUsDateString = "12/31/2012";
IFormatProvider enUsDateFormat = new CultureInfo("en-US").DateTimeFormat;

DateTime date = DateTime.Parse(enUsDateString, enUsDateFormat);

IFormatProvider nlBeDateFormat = new CultureInfo("nl-BE").DateTimeFormat;
string nlBeDateString = date.ToString(nlBeDateFormat);

This will, however, also include the time component in the output. If you don't want that, try e.g.:

IFormatProvider nlBeDateFormat = new CultureInfo(…).DateTimeFormat.ShortDatePattern;
//                                                                ^^^^^^^^^^^^^^^^^

edited Aug 17, 2012 at 19:00

answered Aug 17, 2012 at 18:28

stakx - no longer contributing

85.1k20 gold badges176 silver badges277 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user8128167 Over a year ago

Your last line of code gives me this error: Error CS0029 Cannot implicitly convert type 'string' to 'System.IFormatProvider'

LolliPop · Accepted Answer · 2019-01-02 00:10:06Z

1

This works fine for me:

DateTime date = 
DateTime.ParseExact("20122018", "dd/MM/yyyy", 
                   CultureInfo.CurrentCulture);

answered Jan 2, 2019 at 0:10

LolliPop

1171 silver badge7 bronze badges

Collectives™ on Stack Overflow

converting string to datetime issue

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related