Date input from Excel

Help
, ,
1

Hi I need to pass the date from Excel to Application through uipath. Date in the excel is in dd/mm/yyyy format but while doing the job Uipath is inputting the date in US format . How do I achieve to send the date in dd/mm/yyyy format ?
FYI , in my excel date is in right format as I want .

2

Hi @AshLearnUI,
Please check the below zip folder i developed it as per your requirement including the excel file.

time_Conversion.zip (48.1 KB)

Let me know if you have any doubts.

Cheers.
Vashisht.

2 Likes
3

Thank you @Vashisht . I don’t want to pass time , it is just the date in dd/mm/yyyyy format i would need to pass.
Would you change it for the date only format please . Thanks in advance .

4

Please check the below attached file…

time_Conversion.zip (18.8 KB)

Cheers.
Vashisht.

3 Likes
5

Hi @AshLearnUI,

Did it work?

Cheers.
Vashisht.

1 Like
6

Hello @AshLearnUI , You can follow these steps

  1. Use an Assign activity to assign to a variable named inputDate, value of VB expression -
    Convert.ToDateTime(In_TransactionItem.Item(“DateFromExcel”)).ToString(“dd/mm/yyyy”)
  2. Now use inputDate variable in the Type Into activity to pass the date to the application
1 Like
7

Yeah , it worked for me . Thank you @Vashisht .

1 Like
8

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