SAGE Formula

Question

I have a formula in my SO picking sheet it puts different words on the header depending on the number of days between the order date and the ship expire date. 
 
 I want to edit this formula that the < 4 is actually 0 to 3 Business days. before the wording on the form changes 
 same with the > 4 <8 needing to be workdays only 
 
 in excel I would use the <4,workday then 
 would it be the same for SAGE?

BigLouie · Accepted Answer

This is actually a Crystal Reports question. Normally I Google what I need in Crystal and normally find something like this: 
 You can calculate number of weekdays in crystal reports. 
 In report create a formula and enter the following code. 
 
 // This formula does not account for holidays 
 // I am using Shared variable so that I can use in my subreports 
 
 Shared DateTimeVar d1 := {Orders.Order Date}; 
 Shared DateTimeVar d2 := {Orders.Ship Date}; 
 DateDiff ("d", d1, d2) - 
 DateDiff ("ww", d1, d2, crSaturday) - 
 DateDiff ("ww", d1, d2, crSunday)

Sage 100

SAGE Formula

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING