Max Date - last 10 days

[faisal9999]

I have data including date column total record 100 and I do not know the date range I only want last 10 days data from max(date) from my data.

max(date) - 10 days

[binuacs]

@faisal9999 one way of doing this with the sort and the sample tool

[faisal9999]

Hi Dear....
No it wont work if you have duplicate date then it will take duplicate date as well...Solution that you gave will work on unique rows. 

[binuacs · Accepted solution]

if you want to include the duplicate date as well then try the below workflow

[faisal9999]

thank you so much  

:)