Using date in ifelse function

I want to create a calculated field where it involves date filter condition in it.

For Example:
ifelse( {currentSensorDate}>{fromDateCondnl} AND {currentSensorDate}<{fromDateCondnl},1,0)

I do not want to apply the filter from filter section instead I want to control it inside the calculated field itself. Is there any way to do so?

Hi @Nikhitha
you can create that field but you then have to filter on the new field (0 or 1)