This topic is locked
[SOLVED]

 Filtered by year and month

6/5/2017 10:11:48 AM
PHPRunner General questions
A
apowazniak author

I have a date datefiel dd/mm/yyyy and I need to filter by month and year, any suggestions?

dermemo 6/10/2017

Set up a second dummy field in the query for you date field.
For example:
select

date as month,

date as year

from

database
then on the fields tab add the two filters as interval slider, one as month, one as year.
properties => filter as => interval slider => slider step (month) / (year)

A
apowazniak author 6/11/2017

great!!! thanks