I recently wanted to be able to show the dates in a filter with the most recent dates at the top (sorted descending). Within a filter you can usually change the sort order by changing the default properts > sort. However, this does not work with date data types.
Unless you select 'individual date and time'. See the walkthrough below...
As you would for any other field, change the default sort order to what you would like - here I am changing it to sort (by data source order) descending.
Place the date field into the filter box with a right click and drag - select 'individual date and time' - this will show in the order you have chosen (the other options do not)
Then you can change the format of the date, go back to default properties and change the format - here I am going to show the day, month and year.
And that's it! If you want to filter by different parts of the date like you would usually have the option to do (i.e., MY (just the month, year like the first example) you should create a calculated field first that truncates the date first before following these steps.
