What if you need to write a custom logic in CRM to determine expected end date of something? Like I open an opportunity on 1st January 2012 and it is expected to be closed in 7 working days. Close by date must be updated automatically through table level script. Seems to be pretty much straight forward work right? But it\u2019s not. When you say working days we need to calculate Close by date excluding weekends as we don\u2019t use standard holiday sets and working hour\u2019s configurations here.
\nHere is how you can exclude those Saturdays and Sundays using simple select query.
\nUpdate Opportunity
\nset oppo_closeby=(SELECT case DATEPART(dw, oppo_opened)
\nwhen 6 then oppo_opened + 4
\nwhen 5 then oppo_opened + 4
\nelse oppo_opened +2 end as CloseByDate)
\nwhere oppo_opportunityid = 6001<\/p>\n","protected":false},"excerpt":{"rendered":"