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