Hello,

I have a calculation that shows Active Jobs in a portal... here is the calculation.

Case (jb_date_end ≥ ( Get ( CurrentDate ) );"Active")

It works, but we have found out that some employees' jobs don't necessarily have a job end date (jb_date_end)... so how do I add if jb_date_end is null - job is also active?

Thanks in advance

Sounds like a job for a multicriteria relationship:

gToday>=StartDate

gToday<=EndDate

Each record displayed in a portal through this relationship should be active.

I misspoke... I have a portal that shows Jobs (all jobs- active and not)... but on the active jobs I want the word "Active" to display for that row

Some jobs do not have an end date and do not need an end date... I am having problems adding the null end date into the calculation.

Thanks for the quick response.

case (jb_date_start >= get(currentDate);

case(isempty (jb_date_end ); "Active";

jb_date_end >= get(currentDate); "Active")

)

Is one possibility.

Case ( jb_date_end ≥ Get (CurrentDate) or not jb_date_end ; "Active" )

is another.

Thanks bunches to the both of you.

Edited June 16, 200619 yr by Guest