I am busy with the development of a robot and I have ran into a problem where I have to filter through five different columns using the “Filter data table” activity. I want to filter by country, product, submitted, pending and on today’s date. The problem is that all filters work except the filter on today’s date. UiPath reads the date from Excel in US format with date and time when I use the message boxes, but when I put the contents of the message box in the “Filter Wizard”, I do not get the desired result. I have tried different types of .Net variables like “DateTime.ParseExact”, “DateTime.Now” and “Now.ShortDateToString” and asked other people about this problem but they could not help me.
Does anyone have an idea where it might be?