Ticker filter date

Hello

I have a dataset containing the speeches of the speakers of a meeting. I try to display on a tricker the intervention in progress and on a second the following intervention. For that I use the following filter:
dateDebut<NOW() AND DateFin>NOW()
on the first

And on the second tricker:
dateDebut<NOW() + INTERVAL 15 MINUTE AND DateFin>NOW() + INTERVAL 15 MINUTE

It works, but as the duration of intervention are variable I would like to replace the 15 by a variable.
For that I record the duration of the intervention in a “hard” field of the dataset and I would like to replace the 15 of “+ INTERVAL 15 MINUTES” by the value of this field

I tried with the formula:
dateDebut<NOW() + INTERVAL (SELECT dure WHERE dateDebut<NOW() AND DateFin>NOW()) MINUTE AND DateFin>NOW() + INTERVAL (SELECT dure WHERE dateDebut<NOW() AND DateFin>NOW()) MINUTE

but it sends me an error. Can you give me the syntax to bring back the value of this field in the filter.

dataset structure
Salle Chaîne
dateDebut Date
DateFin Date
Orateur Chaîne
Contenu Chaîne
dure Chaîne

Thank you

dateDebut<NOW() + INTERVAL 15 MINUTE AND DateFin>NOW() + INTERVAL `dure` MINUTE

should work we think.

1 Like