How to Select MTD Date Range on Daily Basis

Help StudioX
1

Date Range

Please help me on this, how to Select MTD Date Range on Daily Basis.

2

Hi @Vijay_R1

Could you elaborate the question clearly then we will get better understanding of it.

3

Hi mkankatala,

I want to download the data from website on “Month to Date”.

This data I will download on daily basis and I have done all the process.

Now I’m stuck in date range part, that I want to know how to select the range from 1st Jul-2023 to 19th Jul-2023.

The same step I want to run on daily basis.

4

@Vijay_R1

  1. Create two variables to hold the start date and end date:
  • currentDate = Now
  • startDate = New DateTime(currentDate.Year, currentDate.Month, 1).ToString(“dd/MM/yyyy”)
  • endDate = currentDate.ToString(“dd/MM/yyyy”)
  1. Use the “Type Into” activity to input the date range:
  • For the start date field - Use the “Type Into” activity to input the value of the startDate variable into the start date field on the website.
  • For the end date field - Use the “Type Into” activity to input the value of the endDate variable into the end date field on the website.

Hope it helps.

5

You don’t need to create the variables. You can just put the expressions directly into the Type Into activities.

6

Can’t you just Type Into or Set Text into the text boxes for the dates?

If it won’t let you do that, you’ll have to create dynamic selectors to click the dates you want.

7

Hi Paul,

Am very new this UiPath, yes I want use dynamic selectors to click the dates.

From the website I cannot type the date manually, it’s only option to select the “Date Range”.

In this situation I don’t know what to do. Can you please help me on this.

8

Thanks Supriya,

This i’ll do the steps as well.

9

@Vijay_R1

Pass the two variables in the type into activities strict selectors.

10

@Vijay_R1

Please check this and try implementing similar to it…it is the same requirement with different website

Cheers

11

Hi Anil, thanks.

Am unable to open the attachment and getting error.

image
image717×205 10.5 KB

12

@Vijay_R1

Please follow the screenshots…I have uploaded those as well

I have created it in studio and not in studiox

cheers

13

Try the Set Text activity. It often lets you set the value of fields you cannot Type Into.

Otherwise, open UI Explorer, click a date, and show us the selector it gives you.

14

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