CR 9 Select Expert Null Formula 2

[VickieT]

Good Morning

In CR 9 I have an age list of employees but don't want to include terminated employees so if I use this formula:
(
isnull({ESYEMPLR.TERM_DATE})
)
it does take out any employee with a termination date but it leaves out employees who have a termination date but were rehired and have an adjusted service date so I tried this:

If not isnull({ESYEMPLR.TERM_DATE})
and ({ESYEMPLR.TERM_DATE} < {ESYEMPLR.adj_service_date})then ({ESYEMPLR.adj_service_date})
else if isnull({ESYEMPLR.TERM_DATE})then ({ESYEMPLR.HIRE_DATE})

but it keeps giving me an error that a boolean is required here. Can you help please? Thanks so much.

 

[synapsevampire]

Try

(
not(isnull({ESYEMPLR.TERM_DATE}))
and ({ESYEMPLR.TERM_DATE} < {ESYEMPLR.adj_service_date}
)
or
(
isnull({ESYEMPLR.TERM_DATE})
)

-k

 

[VickieT]

I put your formulain and it says the ) is missing. Any ideas? Thanks so much for responding so quickly.

Vickie

 

[kchaudhry]

Try this:

(
not(isnull({ESYEMPLR.TERM_DATE}))
and ({ESYEMPLR.TERM_DATE} < {ESYEMPLR.adj_service_date})
)
or
(
isnull({ESYEMPLR.TERM_DATE})
)

This is synapsevampire's formula with an extra ")"

Kchaudhry

 

[VickieT]

Thanks so much to you both. It's working great now.