Filter Dates from CSV

Hi. I’m reading in dates via a CSV. I have an install date (which is separate) and I need to find out if any of the dates fall between ten days before the install date and the install date.

I’m writing the results to a csv file but there is nothing writing. I think it is because the dates are reading in as strings.

Any ideas?

Thanks

When you read data from a CSV, its default format is text. Can you post the format of the dates in your CSV?

image

After you read the date into a string (e.g. MyStrDate), convert it to a datetime (MyDate = Date.ParseExact(MyStrDate, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture). Then you can use this date for comparison when you’re determining what results you want to write.

@Vicky_Fegan Can you show us the implementation what you have done in a Screenshot, Maybe we can Correct some places and get the workflow running.