Skip to content

Instantly share code, notes, and snippets.

@nicksambrato

nicksambrato/Target_Ship__c

Created October 1, 2016 17:10
Show Gist options
  • Save nicksambrato/ca0ce4220458bfe39e42fbb3c08be46c to your computer and use it in GitHub Desktop.
Save nicksambrato/ca0ce4220458bfe39e42fbb3c08be46c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Target_Ship__c
IF ( ISBLANK (Hard_Ship__c) && ISBLANK (Date_Order_Approved__c),
CASE(
MOD(today() - DATE(1900, 1, 7), 7),
0, (today()) + Total_Turnaround__c + FLOOR((Total_Turnaround__c-1)/5)*2,
1, (today()) + Total_Turnaround__c + FLOOR((Total_Turnaround__c)/5)*2,
2, (today()) + Total_Turnaround__c + FLOOR((Total_Turnaround__c+1)/5)*2,
3, (today()) + Total_Turnaround__c + FLOOR((Total_Turnaround__c+2)/5)*2,
4, (today()) + Total_Turnaround__c + FLOOR((Total_Turnaround__c+3)/5)*2,
5, (today()) + Total_Turnaround__c + CEILING((Total_Turnaround__c)/5)*2,
6, (today()) - IF(Total_Turnaround__c>0,1,0) + Total_Turnaround__c + CEILING((Total_Turnaround__c)/5)*2,
CASE(
MOD(Date_Order_Placed__c - DATE(1900, 1, 7), 7),
0, (Date_Order_Placed__c) + Total_Turnaround__c + FLOOR((Total_Turnaround__c-1)/5)*2,
1, (Date_Order_Placed__c) + Total_Turnaround__c + FLOOR((Total_Turnaround__c)/5)*2,
2, (Date_Order_Placed__c) + Total_Turnaround__c + FLOOR((Total_Turnaround__c+1)/5)*2,
3, (Date_Order_Placed__c) + Total_Turnaround__c + FLOOR((Total_Turnaround__c+2)/5)*2,
4, (Date_Order_Placed__c) + Total_Turnaround__c + FLOOR((Total_Turnaround__c+3)/5)*2,
5, (Date_Order_Placed__c) + Total_Turnaround__c + CEILING((Total_Turnaround__c)/5)*2,
6, (Date_Order_Placed__c) - IF(Total_Turnaround__c>0,1,0) + Total_Turnaround__c + CEILING((Total_Turnaround__c)/5)*2,
NULL)), NULL)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment