Assign: The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar

Help Activities
, ,
1

Assign: The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar.

my excel as below.
image

My flow as below.
variable excelDate as Datetime.

image
image723×279 9.89 KB

It can run row 1 and row2 but in row 3 → error.

Please guide me for solve it.

2

@fairymemay ,

It is due to the format issue, I think your system may have the date format as MM/dd/yyyy.

Another thing, check in debug mode, during the 3rd row split check what is the value available in the 0 index after splitting it.