Error on date conversion

prabhu p

8y1.1k.NET

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
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);
Amit Gupta8y ago
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
Bhavesh Jadav8y ago
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