+ Start a Discussion
Stavros McGillicuddyStavros McGillicuddy 

Close date + 1 business day with workflow

I am trying to modify this code (found on forums) to update the Expected_Ship_Date__c to CloseDate + one business day
Im not getting any errors but, the field is not updating

Monday + 1
Tuesday  + 1
Wednesday  + 1
Thursday  + 1
Friday + 3
Saturday + 2
Sunday  + 1
CASE(MOD( CloseDate - DATE( 1900, 1, 7 ), 7 ), 
1, CloseDate + 1, 
2, CloseDate + 1, 
3, CloseDate + 1, 
4, CloseDate + 1, 
5, CloseDate + 3, 
6, CloseDate + 2, 
CloseDate + 1 
)

 
SalesFORCE_enFORCErSalesFORCE_enFORCEr
I tested it by creating a formula field with same logic and it works fine. Can you make sure that workflow is triggering?
Stavros McGillicuddyStavros McGillicuddy
I had expected this to fire every time I edited an opportunity where Opportunity Won = True. I ended up changing the criteria to Opportunity Stage = Closed Won. If I change the an existing Opportunity Stage Closed Won to something else, save it and change it again to Closed Won it works