IF to SET Analysis conversion question

[#1]

Hi Experts,

Is it possible to convert the follwing expressions into set analysis

max( if (ORD_DT <= '5/18/2007',ORD_DT))

COUNT(DISTINCT if (ORD_DT<= '4/18/2007', ORD_ID))

Thanks,

Aji Paul.

[sushil353]

try this:

Count({<ORD_DT={"<=4/18/2007"}>} DISTINCT ORD_ID)

Max({<ORD_DT={"<=5/18/2007"}>} ORD_DT)

if "" (double quotes) doesn't work then try with '' (single quotes).

HTH

Sushil