Dynamic Range Selection to Download Data from Website

Help
, , ,
1

Hi,

Can you please advise once i login into website, i have to choose the drop down and select the field and input the date range.

The Date range would be Today(-) 1 day and end date would be 2 weeks or 1 week.

Please advise as how i can use bot to select the data dynamically based of above criteria and download the CSV.

dynamic range

thanks,

2

Hi @aladin347

use these things in Date and To Date.

Date - date.Now.AddDays(-1).toString(“dd-MM-yyyy”)
To Date - date.Now.AddDays(7).toString(“dd-MM-yyyy”)

Regards,
Kommi Jeevan.

1 Like
3

Thank you, i will look into this and ask if any questions.

4

From Date as Date.Now.AddDays(-1).ToString(“M/d/yyyy”)
To Date as Date.Now.AddDays(-7).ToString(“M/d/yyyy”) or Date.Now.AddDays(-14).ToString(“M/d/yyyy”)

Cheers! @aladin347

1 Like
5

Thank @kommijeevan

I used the above formula but added + enter as it was entering duplicate values in browser.

Date.Now.AddDays(-1).ToString(“dd/MM/yyyy”)+ “[k(enter)]”

6

please send screenshot?

7

@kommijeevan

typeinto

8

here typing yesterday date or not?

9

Its adding

10

it’s working fine or not?

11

Cheers @aladin347 if you find it useful mark it as solution and close the thread.

12

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