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?

Thanks!!

May I know what error u r getting

@anushka.prasad

hi @anushka.prasad

try datatype DateTime

It Helps!

@anushka.prasad

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

cheers

This works!
Thanks a lot!!

1 Like

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