c# - How can I convert a date from the format "dd/mm/yyyy" to "yyyy/dd/mm"? -

i have textbox in user supposed enter date in format dd/mm/yyyy, date stored yyyy/mm/dd in database.

so want user enter date in dd/mm/yyyy format , later want convert yyyy/mm/dd can query database.

how can convert user input date dd/mm/yyyy yyyy/mm/dd?

quick , maybe dirty:

string reformatteddate = datetime.parseexact(textbox1.text, "dd/mm/yyyy", null).tostring("yyyy/mm/dd"); 

this, of course, assumes content of textbox in assumed format, should checks in before ensure that. there's safer way not need additional checks:

datetime result; if(datetime.tryparseexact(textbox1.text, "dd/mm/yyyy", null, system.globalization.datetimestyles.none, out result) {     // here can safely use result     string reformatteddate = result.tostring("yyyy/mm/dd"); } else {     // screw user } 

this try parse content of textbox , return via out result, if successful, return true. otherwise can rest assured input either not in assumed format, or not valid date.

please aware parseexact throw argumentnullexception or argumentexception if conversion fails.

• msdn article parseexact
• msdn article tryparseexact

i have text box in user supposed enter date in dd/mm/yyyy format, date stored yyyy/mm/dd in database.

the obvious answer is: use datetimepicker , parameterized query before wrestling string conversion. save a lot of headache in long run.