Hi, need help.
I have some dates like in “sales date” column in a datatable
I want dates which are less than or equal to 7 days from now.
In the above case it will be 16 sept and above.
So I used one assign activity like below:
NewDate = DateTime.Today.AddDays(-7).tostring(“MM/dd/yyyy”)
Then I used Filter datatable activity and tried to filter like below:
“sales date” >= NewDate.tostring
But executing above function is not giving me any result.
Can you please help?