I’m having an issue comparing the date in a csv file. I have a condition that should only add rows where the following condition is met however, it’s bringing in incorrect data:
((row(“StartDate”).ToString) > Datetime.Today.AddDays(-7).ToString(“dd/MM/yyyy”))
My condition should only show rows where the date is from the last week, however i’m getting data from months too.
Data in the CSV file is already formatted to dd/MM/yyyy…
Can anyone help?