Beginner to RPA and looking for some help, hope this makes sense.
Looking to build out a report and it works off an extracted CSV file.
Column1 in the CSV has a set string when extracted in the sense of MM\dd\yyyy 6:00 up until the current time when extracted. I need to extract all the rows between MM\dd\yyyyy 6 until MM\dd\yyyyy HH and build it into another datatable. I am able to extract anything that has the current hour at that moment. But i am having trouble doing a between both.
Right now i have For Each loop with an if statement that var.Contains(DateTime.Now.ToString(“MM\dd\yyyy HH”) returns all values that start with the hour. How can i get anything that starts from 6 that current day.
Any help would be greatly appreciated.