Previous and Next Working Day Calculations
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.