Error on date conversion

Question

I converting date format from MM/dd/yyyy to dd/MM/yyyy

for example

from date 03/01/2018( MM/dd/yyyy ) textbox format

To date 03/27/2018( MM/dd/yyyy ) textbox format

I want to convert to dd/MM/yyyy for DB

DateTime dt = DateTime.ParseExact(from, "dd/MM/yyyy", CultureInfo.InvariantCulture);

No error for from date

DateTime dt1 = DateTime.ParseExact(To, "dd/MM/yyyy", CultureInfo.InvariantCulture);

error on above line dt1 String is not valid datetime

what happening in todate after converting to dd/MM/yyyy it will be 27/03/2018 and system taking 27 as month and showing error .

Please help on this

Thanks in advance

Bhavesh Jadav · Answer

Hi Prabhu, Try below code for Todate DateTime dt1 = DateTime.ParseExact(To.ToString(), "MM/dd/yyyy hh:mm:ss tt" , System.Globalization.CultureInfo.InvariantCulture); string s = dt1.ToString( "dd/M/yyyy" , System.Globalization.CultureInfo.InvariantCulture); for more reference refer below links : https://stackoverflow.com/questions/5050102/convert-datetime-to-date-format-dd-mm-yyyy https://www.codeproject.com/Questions/719495/How-to-insert-date-in-dd-MM-yyyy-format-using-Csha I think you will get your solution. Thanks

Amit Gupta · Answer

I want to convert to dd/MM/yyyy for DB Which db you are using? DON'T do that, displaying to user in various fprmat is only display purpose only. If you convert it to any other format, you will loose important datatype. Db saves datetime in universal format, we can see in sql like yyyy/MM/dd

Rafnas T P · Answer

hi, when you send to database convert datetime to yyyy/MM/dd format so that no error will come try below code to convert DateTime dt1 = DateTime.ParseExact(To, "yyyy/MM/dd", CultureInfo.InvariantCulture);