Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add 3 days or Mod function

Status
Not open for further replies.

bta1322

Technical User
Oct 28, 2010
20
GB
Apologies for accidentally high-jacking a posted thread (Skip Vought) - Wondered why i did not see it displayed

I am a newbie, end used in BO (webI). No sure of the terminology correct
I want to add 3 days to a date and time, using the following criteria:-
Examples:

Adding 3 days
Mon 18/01/10 07:00:00 result should result 21/01/10
Mon 18/01/10 16:51:00 result should result 22/01/10
Sat 23/01/10 any time result should result 28/01/10
Sun 24/01/10 any time result should result 28/01/10
Mon 6/3 00:51:00 result should result 10/3
In short, anything after 1600hrs the calculation would start from the following day, weekends are not counted at all, and the calulation will be from the Monday. Any time before 1600hrs will count as day one)


Currently using in Excel, where D2 = "Call-over date & Time"
=WORKDAY(IF(OR(WEEKDAY(D2,2)>5,MOD(D2,1)>TIME(16,0,0)),WORKDAY(D2,1),D2),3))

I now using BO and generate a report, and wanted to add a variable column, rather than keep exporting report into Excel

Trying to compose variable for this complicated formula is above my level, I might be able to split the formula up, howver, I am stuggling with the MOD function, and how to enter it in BO

Any help, or pointing in the right direction, will be appriciated

Brian

 
You trying to do this in the report or in the universe?

Steve Krandel
Intuit
 
Hi steve

In the report, i was hoping to add a column with a variable (if this is the right terminology?)

brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top