There is a website of which I want to get data from and paste it into an Excel sheet.
I choose “Global (English)” for "Country, then “Services”, than “Tax” and then “View All Tax Documents”.
I made an input box in which a user can enter a date. The idea is that the robot stops when the robot is at the date the user entered.
This works, but there is a problem: there are days, such as the 29th of July, on which no documents were uploaded. So if I type 29-07-2017 (I already made the robot convert Jul to 07), the robot will run virtually endlessly.
I compared this:
to the date the user entered.
RawMaand is just the month the user entered, RawJaar is the year, both are in String format.
d1 is the first digit of the day the user entered, d2 is the second digit.
So when a number lower than d1d2 is found, together with the same month and same year that the user entered in the input box, a variable called “DatumBereikt” (which is Dutch for “DateReached”) will be changed from “false” to “true”, which causes the robot to stop (Boulean)
However, I think UiPath is not recognizing the RegEx I used in a proper way, I have the feeling that it literally searched for [0-“digit entered”][0-“digit entered”]-month-year, rather than “everything lower than”.
Does anyone know what I did wrong, and what I can do to solve the problem?
Thank you in advance!