Jump to content

Pls. help with "Active" calculation


This topic is 5654 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5654 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.