Hi, try this:


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


Regards,
Anderson

----- Original Message -----
From: "william_yuwei" <william_yuwei@...>


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 ...