Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
YOUR VOICE MATTERS! VOTE FOR OUR NEXT WEBINAR TOPIC NOW.
Click on this link for the poll.

Formula To Return Employee Name If Project Role End Date Is In the Future

Hi Community

I have a project saved search showing me projects ending within the next three months and this is working correctly. Now I want to see the 'active' project task employees (we call them resources). By active I mean their project task role start date is not in the future and project task end date is not in the past.

The Resource field ID is: {projecttask.custevent_hw_resource}

The Role End Date ID is: {projecttask.custevent_hw_role_end_date}

Any idea how I can structure a formula to show me the {projecttask.custevent_hw_resource} is the {projecttask.custevent_hw_role_end_date} is not in the past (or is in the future)?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders