how to change format of a date string in asp.net

Question

I have a date string like "30/01/2018" and I want a format like "2018/01/30"

I have tried the following lines,

DateTime.Parse(startDate.Text.ToString()).ToString("yyyy/MM/dd");

and

DateTime.ParseExact(startDate.Text.ToString(),"dd/MM/yyyy").ToString("yyyy/MM/dd");

but didn't work. Anyother solution?

Your code uses the default locale of your server or client machine where it executes. If the locale cannot understand the format of your strings it cannot convert to a proper datetime value. What is the locale where this code runs? (By the way, Text is already a string property, no sense in calling ToString on it) — Steve
– Steve, Commented Jan 30, 2018 at 7:38
Also there is no overload of ParseExact with only two arguments, the same for the first example. Both don't compile if you don't add a CultureInfo parameter — Steve
– Steve, Commented Jan 30, 2018 at 7:41

Nino · Accepted Answer · 2018-01-30 07:48:15Z

6

try like this

string newFormat = DateTime.ParseExact("30/01/2018", "dd/MM/yyyy", CultureInfo.InvariantCulture)
    .ToString("yyyy/MM/dd", CultureInfo.InvariantCulture);

answered Jan 30, 2018 at 7:48

Nino

7,1152 gold badges29 silver badges46 bronze badges

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

Comments

Kung Fu Panda · Accepted Answer · 2018-01-30 07:40:25Z

3

If you want output in string. Why not split and re-arrange?

string strOldFormat = "30/01/2018";
string[] strArrOldFormat = strOldFormat.Split('/');
string strNewFormat = strArrOldFormat[2] + "/" + strArrOldFormat[1] + "/" + strArrOldFormat[0];

answered Jan 30, 2018 at 7:40

Kung Fu Panda

64610 silver badges22 bronze badges

Comments

grek40 · Accepted Answer · 2018-01-30 07:59:09Z

3

Escape your slashes (and use a Culture with ParseExact)

DateTime.ParseExact("30/01/2018","dd/MM/yyyy", CultureInfo.InvariantCulture)
    .ToString(@"yyyy\/MM\/dd")

Or use the InvariantCulture for the ToString instead of escaping the slash:

...ToString(@"yyyy/MM/dd", CultureInfo.InvariantCulture)

Reason is, that / is a special format character for dates:

Custom Date and Time Format Strings - The "/" custom format specifier

The "/" custom format specifier represents the date separator, which is used to differentiate years, months, and days. The appropriate localized date separator is retrieved from the DateTimeFormatInfo.DateSeparator property of the current or specified culture.

edited Jan 30, 2018 at 7:59

answered Jan 30, 2018 at 7:45

grek40

13.5k1 gold badge29 silver badges54 bronze badges

6 Comments

Steve Over a year ago

it is the backslash character that needs to be escaped not the forward slash.

grek40 Over a year ago

@Steve does the edit answer your concerns? And backslash doesn't need escape with @"string"

Nino Over a year ago

you don't need to escape it. Just use CultureInfo.InvariantCulture in ToString() method and you don't have to worry about culture's date separator.

Steve Over a year ago

@grek40 as you don't need the verbatim character before the first dd/MM/yyyy you don't need it and the backslash before the second

grek40 Over a year ago

@Nino yes, I already mentioned this as a second option... but still it's equally valid to escape a special character in order to use it literally :)

|

Sanket · Accepted Answer · 2018-01-30 11:54:38Z

2

Try using below sample code:-

var  actualStartDate = DateTime.ParseExact(startDate.Text.ToString(),"yyyy/MM/dd", CultureInfo.InvariantCulture);

edited Jan 30, 2018 at 11:54

answered Jan 30, 2018 at 11:23

Sanket

4525 silver badges19 bronze badges

Comments

Xar Hang · Accepted Answer · 2018-01-30 09:14:28Z

1

you can try this code

string dateString = startDate.Text.ToString();
string format="yyyy/MM/dd"; 
string result;
CultureInfo provider = CultureInfo.InvariantCulture;
result = DateTimeOffset.ParseExact(dateString, format, provider).ToString();

or You can bundle it into one line like this

string result = DateTimeOffset.ParseExact(startDate.Text.ToString(),"yyyy/MM/dd", CultureInfo.InvariantCulture).ToString();

more information here

answered Jan 30, 2018 at 9:14

Xar Hang

2110 bronze badges

1 Comment

Xar Hang Over a year ago

more information learn.microsoft.com/en-us/dotnet/api/…

Cansel Muti · Accepted Answer · 2018-01-30 14:05:42Z

1

You can use this;

String.Format("{0: yyyy/MM/dd}", yourDate);

answered Jan 30, 2018 at 14:05

Cansel Muti

6082 gold badges10 silver badges23 bronze badges

Collectives™ on Stack Overflow

how to change format of a date string in asp.net

6 Answers 6

Comments

Comments

6 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

6 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related