Error in converting data from Generic value to DateTime using Format Value activity

[kkpatel (Kamal)]

Hi
I am getting error "Cannot convert Generic Value to System.DateTime.
Attaching my work flow.Main.xaml (7.6 KB)

[Yoichi]

Hi,

Probably your data doesn’t exactly fit datetime type such as including some whitespace.

Can you try modify Assign activity in For Each as the following.
date_Value = item.ToString.Trim

Or check your data is not empty and exactly fit datatime type in debug mode etc.

Regards,

[SowmyaLeo (Sowmya Sivakumar)]

Please check this link if it helps:

Get time format value from Excel Coulmn

Hi I am trying to get time from excel column, once i had declared DateTime type variable it showing error “Date and Time Converter Can not Convert from System.Double” When I tried in double type variable output came as below, I tried converting double to date again, could not work, Please HELP [DoubleTypeOutPut] Excel Column Format [image]