How to fill in a date indicated in an Excel to a calendar field in an online form?

Help Studio
, ,
1

I want that the robot type into the calendar field a specific date indicated in an Excel.

When using activity “type into” It does the job but incorrectly. instead of putting the correct date 28/04/1980 he put 04/28/19800000000 (see attached for the explanation).

Issue Type into wrong date.docx (312.3 KB)

Do you know what’s going wrong?

2

@mce

You can use as below in TypeInto

Convert.ToDateTime(row.item("Date of Birth").ToString)("dd/MM/yyyy")

Hope this may help you

Thanks

3

Hi Srini84,

I’ve tried your solution but I’ve got the following compile error(s) encountered processing expression message :

Expression is not an array or a method, and cannot have an argument list.

image
image1279×607 41.8 KB

4

@mce

Oh, sorry, can you try below

Convert.ToDateTime(row.item(“Date of Birth”).ToString).ToString(“dd/MM/yyyy”)

Hope this may help you

Thanks

5

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