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)