Hi, All

I tried to put like this into where clause, and it failed:

where IIF(CONTACT_DATE is not null, CONTACT_DATE between :startdate
and :enddate, INJURY_DATE between :startdate and :enddate) and ...

Why I can not use IIF in where clause?, will it be a new feature in
the future release in FB2.1+ or FB3?

Thanks

William