How to create a filter with stored dates
Hello,
I have a Date field in my form with the name TransferDate.
I would like to create a filter so I have enabled it from the 'Auto Filters' menu.
The filter is working like the below image. It shows me 'month - year'.
Is it possible to customize this filter to show me all the dates which are stored in the database?
I mean the filter to be like:
TransferDate:
10-05-2017
28-06-2017
20-07-2017
.
.
.
and when I click the '28-06-2017' then to return me all the records with this TransferDate?
Maybe someone will tell me to manually add one by one the stored dates. I do not want to do that as I daily add new records with new dates.
It is like the 'Grouping' which you have in the 'Grouping & Sorting' but I would like to have it as a filter.
I have a Date field in my form with the name TransferDate.
I would like to create a filter so I have enabled it from the 'Auto Filters' menu.
The filter is working like the below image. It shows me 'month - year'.
Is it possible to customize this filter to show me all the dates which are stored in the database?
I mean the filter to be like:
TransferDate:
10-05-2017
28-06-2017
20-07-2017
.
.
.
and when I click the '28-06-2017' then to return me all the records with this TransferDate?
Maybe someone will tell me to manually add one by one the stored dates. I do not want to do that as I daily add new records with new dates.
It is like the 'Grouping' which you have in the 'Grouping & Sorting' but I would like to have it as a filter.