Data scrape the below table from a website, want to return every value in the in the transaction date column. Then with the rows and columns returned add up the transaction amount. So for example variable (a) with the value 03/09/2022 00:00:00 (MM/dd/yyyy) and variable (b) with the value 04/13/2022 00:00:00 (MM/dd/yyyy) so any thing inbetween these two date will be returned so that would be “Thursday 24-Mar-2022” and “Friday 08-Apr-2022”.
Once the dates inbetween the two variable have been returned i want to add up any scheduled payments amounts that returned with these days so that would be the two values £535.90 and £535.94.
Use extract table to extract the data from website
Then use a for each row in datatable activity to loop theough the datatable
Now inside the loop use a if condition with Date.Compare(datetime.parseexact(currentrow("date olumnname").ToString,"dddd, dd-MMM-yyyy",System.Globalization.CultureInfo.InvariantCulture,datetime.parse(variablea) > 0 and Date.Compare(datetime.parseexact(currentrow("date olumnname").ToString,"dddd, dd-MMM-yyyy",System.Globalization.CultureInfo.InvariantCulture,datetime.parse(variableb) <0 which will compare if the input date is between variablea and variableb or not
In the then side use assign for sum = sum + cdbl(currentrow(“totalscolumnname”).Tostring.Replace("£”,””).Trim)…Type of sum is double
@Anil_G thanks for you help it looks like the error is gone but now this is the issue i face when running the process. In the image the first value is variable a (string) and the next is variable b (string). would you know how to get around this