Pls. help with "Active" calculation

[agtjazz]

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

[Razumovsky]

Sounds like a job for a multicriteria relationship:

gToday>=StartDate

gToday<=EndDate

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

[agtjazz]

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.

[Razumovsky]

case (jb_date_start >= get(currentDate);

case(isempty (jb_date_end ); "Active";

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

)

Is one possibility.

[comment]

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

is another.

[agtjazz]

Thanks bunches to the both of you.

Edited June 16, 2006 by Guest