AnsweredAssumed Answered

Previous and Next Working Day Calculations

Question asked by RickDearden on Nov 7, 2014
Latest reply on Nov 10, 2014 by philmodjunk

Title

Previous and Next Working Day Calculations

Post

Hi guys,

I have a layout with 3 portals on it.

Portal 1 - Shows Tomorrows Jobs  which are Filtered By Calc Jobs_Logins::Date = ( Get ( CurrentDate ) + 1 )

Portal 2 - Shows Todays Jobs which are Filtered by Jobs_Logins::Date = Get ( CurrentDate )

Portal 3 - Shows Yesterdays Jobs which are Filtered by Jobs_Logins::Date = Get ( CurrentDate ) - 1
 

This is all fine except on a Monday and Friday when the weekend days prevent Friday's and Monday's jobs from being displayed.

What I'd like to do (on Friday only) is for Portal 1 show Saturday/Sunday/Monday's jobs (as though we're looking ahead to the next proper working day) and the reverse on Portal 3 for Monday only where it will show Sunday/Saturday/Friday's jobs. 

I've had a play around with the DayOfWeek ( date ) calculation but can't get it to work. I think it may need a case calculation but they're beyond my grasp at the minute!!

Any help would be much appreciated.

Cheers,

Rick.

Outcomes