ERROR: Assign: Conversion from string "16/03/2020" to type 'Date' is not valid

Hi all,

I am getting this error when i try to convert to date format.

Here is my aktivities and error:

1.datestring: rows.Item(“Date”).ToString

2.date_date: Convert.ToDateTime(datestring)

3.date_date.ToString(“yyyy-dd-MM”)

Hi,

Can you try the following expression instead of Convert.ToDateTime.

Datetime.ParseExact("16/03/2020","dd/MM/yyyy",nothing)

Regards,

1 Like

@mazlumkacar “dd/MM/yyy” give like this

1 Like