Skip to Content
0
Former Member
Jan 03, 2008 at 11:11 PM

Need to return Business Days

29 Views

Post Author: latingntlman

CA Forum: WebIntelligence Reporting

I have two date fields: EstDateofDeparture and EstDateofArrival.

My problem is when EstDateofDeparture falls on a Friday then EstDateofArrival shows on a Saturday and we don't deliver on Saturdays.We do have departures on Saturdays but no pickups on Sats and sundays.

So I need the EstDateofArrival to be the following business day (Monday).Here's an example below:

EstDateofDeparture: Friday, Dec 7th, 2007EstDateofArrival: Saturday, Dec 8th, 2007 (it needs to be Monday, Dec 10th, 2007 -- next business day).

Example # 2:

EstDateofDeparture: Saturday, Dec 8th, 2007EstDateofArrival: Sunday, Dec 9th, 2007 (it needs to be Monday, Dec 10th, 2007 -- next business day).

T-SQL has a functionalilty where you could for example add getdate()-1 or getdate()+2.

But I can't find anything in webi formula editor that shows me how to I can do that.

Is there a function for this??

thx,

John