CR XI - SELECT EXPERT

[CRXIuser2005]

I'm using the following "composite expression" in my select expert and it is NOT working:

{@File Type} IN ["Bankruptcy Files"] and
{Command.WIP_Cost_Dollar_Value} > 0.00 and
{Command.System Closed Date} >( Date (2005, 11,30)-45) or
isnull({Command.System Closed Date})

IT is ignoring the "Bankruptcy Files" text designator???

Any ideas why?

This is based on a table created via UNION ALL STATMENT...JUST FYi..

Thank you.

MV

"A man is only as happy, as he makes up his mind to be....

 

[Turkbear]

Hi,
What is in the @File Type formula?




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Try:

(
isnull({Command.System Closed Date}) or
{Command.System Closed Date} > Date (2005, 11,30)-45
) and
{@File Type} = "Bankruptcy Files" and
{Command.WIP_Cost_Dollar_Value} > 0.00

The null check should be first. Also when using "or" clauses, you must be careful to use parens to show the intended logic. Not sure why you are not hardcoding 11/30 -45 days, but maybe you intend to plug in a parameter?

-LB

 

[CRXIuser2005]

Thanks for you expertise!!!!

Thank you.

MV

"A man is only as happy, as he makes up his mind to be....