Error when get the end date from excel

Help
1

I am trying to pass the excel start date and end date to the webpage.

The excel context in as show below:

05

Then, the date and month in excel file and output in my wegpage are reverse. So, i use this function as well: Date.ParseExact(“dd/mm/yyyy”,strDate.ToString.Trim,System.Globalization.CultureInfo.InvariantCulture).ToString(“mm/dd/yyyy”) to reverse the date and month.

But, when i try use this function in both start date and end date, only start date can give me the output while end date give me this error:

03

and here is my workflow:

04

Can anyone pls help me? Thanks.

2

might be you will get something idea from this

3

Hi @jiejie,

can you try valstart.tostring(“MM/dd/yyyy”) and valend.tostring(“MM/dd/yyyy”)

Regards
Srish

4

@srishsai i try but error.

Screenshot%20(22)
Screenshot%20(22)1920×1080 160 KB

5

@jiejie Here you go ExcelDateChangeFormat.zip (17.6 KB)

6

@indra thanks…

7

@indra may i knw what is this error? Problem click image?

02

8

@jiejie Please Check with click image activity

9

@indra

03

10

@jiejie Can you attach your workflow and specify what you are trying to achieve from the above screen shot I think error is not from the selectors

11

@indra 04 005 006 07
08 09 1

My workflow as about. I try to get the date from excel file and i press submit button. After i submit, the report file will download. Then i will move the download file to c file. And i want to click This Pc to open the c file.

12

@jiejie For moving file instead of click you can use move file activity know
Refer this for moving files.

13

@indra i knw . even after i move file, i also need to click “This PC” , because i need to rename report name, but cannot click into “This PC”

14

@jiejie Have you tried with click image activity

15

@indra yes , i try and it work if only like this.

03

16

For opening ‘This PC’ you can also use Send Hotkeys activity. Use Win + E

Or to directly go to a path in C folder, you can use Win + R with Send Hotkeys activity, which will open the run command, where you can paste the folder name and hit enter

17

Was wondering… you need not open the folder location to open the excel file. You can directly use the Excel application scope activity.

Also you can use the Copy File activities to ‘move and rename’ the file at the same time.
Like,
Source : "C:\Users\Username\Downloads\YourOldFileName.xlsx"
Destination : "C:\MyFolder\YourNewFileName.xlsx"

These may ease your life, if at all you struggling with UI

Refer this :
https://activities.uipath.com/docs/copy-file

18

@kaderms even i use send hotkey “Win +E” , it also show the same error

01
01721×523 30.5 KB

and i use second way as u said

it also show me same error:

02
02746×713 41.9 KB

19

@kaderms and if i directly use Excel Application Scope, and i try to click the image in excel file, it also show me this error:

03
03819×581 41.6 KB

20

I am not sure what are the steps you are following and where you face the issue.
Can you please list down the steps that you are trying to do and at which step you face the issue? Looking at a portion of your workflow doesn’t give the complete picture.
If possible please share your workflow file with the necessary steps too.

Recommended - Please start a new thread as this thread was created for a different issue