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.
When you read data from a CSV, its default format is text. Can you post the format of the dates in your CSV?
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.