Currently im working on a process where i need to filter two datetime columns.
This is the data table here i want to filter data [Sales Date] = DateTime.now.ToString() and [Action taken on] >= DateTime.now.Adddays(-1) and [Action taken on] <= DateTime.now.ToString()
And the below is the expected result
I tried this but its not returning any values.Please help…
TestSample.xls (27.5 KB)