Date prefilter

[poni]

Hi !
How can I set list prefilter with date element.Element show ending date.I want the prefilter show me rows,which all ending 10 days before.
For example, from today I want to see in prefilter list: 15.10.2015 , 17.10.2015 or 19.10.2015 but not 22.10.2015 , 27.10.2015 or 14.11.2015.
The DATE element is formated : %d-%m-%Y (both in the form and list) UTC. How can I made this.
How can I set that in menu prefilter.
I tryed something ,but have a syntax error.Please help

Thanks!

 

[lcollong]

I would do :

field --- condition --- value --- type
Element --- LESS THAN --- NOW() - INTERVAL 10 DAYS --- query

 

[poni]

Nothing , but thanks.Filtering date after certain date + 10 days : 31.01.2016,12.01.2016, .Today is 15.10.2015.
Thank you

 

[troester]

Please don't open multiple threads for the same topic.
http://fabrikar.com/forums/index.php?threads/date-prefilter.42200/

http://fabrikar.com/forums/index.php?wiki/pre-filters/#show-all-records-older-than-a-certain-date
is showing how to do it.
Surely you have to adapt it to your needs, using LESS or GREATER, setting + or - INTERVAL