Taking Sat and Sun out of date look aheads

Yahoo Archive
1
Example #5 To convert a date to the day of the week e.g. 1/1/2007 to Monday.
(If WEEKDAY(LaborHed.ActualClockinDate) = 1 then "Sunday" else
(if WEEKDAY(LaborHed.ActualClockinDate) = 2 then "Monday" else
(If WEEKDAY(LaborHed.ActualClockinDate) = 3 then "Tuesday" else
( IF WEEKDAY(LaborHed.ActualClockinDate) = 4 then "Wednesday" else
(IF WEEKDAY(LaborHed.ActualClockinDate) = 5 then "Thursday" else
(If WEEKDAY(LaborHed.ActualClockinDate) = 6 then "Friday" else
( If WEEKDAY(LaborHed.ActualClockinDate) = 7 then "Saturday" else "0" )))) )) )


This might get you started...Of course, you would put in a different table/field

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of brad_boes
Sent: Friday, November 18, 2011 4:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Taking Sat and Sun out of date look aheads



We are on 9.05.603 and working on a purchasing demand BAQ for a supplier portal view.

We want the BAQ to show demand for the next two days of production.

Does anyone know an easy way to have a calculation "skip" over the weekend days? Longer holiday weekends are even worse for this.

We pull in the extra days using phrase builder criteria, but then are struggling to setup a calculated field and display filter combination that makes sense for this.

Thanks in advance to this great group.

Brad Boes
Metalworks




[Non-text portions of this message have been removed]
2
We are on 9.05.603 and working on a purchasing demand BAQ for a supplier portal view.

We want the BAQ to show demand for the next two days of production.

Does anyone know an easy way to have a calculation "skip" over the weekend days? Longer holiday weekends are even worse for this.

We pull in the extra days using phrase builder criteria, but then are struggling to setup a calculated field and display filter combination that makes sense for this.

Thanks in advance to this great group.

Brad Boes
Metalworks