Datatype of variable in DD.MM.YY format in excel to copy to SAP

Date in excel is in DD.MM.YY format, I am unable to get the datatype for the variable. I am reading the cell through Read Cell activity and saving the value in a variable. String is throwing error.
This variable has to be pasted in SAP.
What datatype should I assign to the variable?


May I know what error u r getting


hi @anushka.prasad

try datatype DateTime

It Helps!


Try setting the variable type to genericvalue…and then use .ToString if you want to convert to string

it is always good to sue generic for read cell activity


This works!
Thanks a lot!!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.