Filter a dataset with today's date

Hi All

Sorry for the this question but I went through the forum and I was not able to adapt answers to my issue.

I have a dataset (resa_dataset) which contains 2 dates (start_date and end_date). I would like to filter the dataset with the following conditions :

  1. start_date <= today’s date
    and 2) end_date > today’s date
    knowing that the dataset is set up on a dynamic page with a filter on a reference id equal the item id of the page (I hop I am clear).

Could someone help me? I’m not so bad in SQL but very poor in Javascript…

Many thanks

Emma