Calculate business days in CRM2013 workflow RRS feed

  • Question

  • I have a need to calculate a future date in a workflow,  over several weeks

    using only business days.  Is there a solution without going to

    some third party option?

    Wednesday, March 19, 2014 2:23 PM

All replies

  • You're probably looking at a custom workflow activity, that's what we have done before to handle this kind of thing. 'Gotchas' to look out for include:

    1. Holidays

    2. Global/timezone concerns (different holidays in different countries, Saturday in one part of the globe is Friday in another)

    Here's one thread on how you might start ... http://stackoverflow.com/questions/1044688/add-business-days-and-getbusinessdays

    Wednesday, March 19, 2014 3:38 PM
  • OOB CRM doesn't have an option to calculate based on business days. However, you can use a custom workflow activity (.Net code) to do the date calculation you need.

    There is a good utility available in codeplex (includes source code). Check if it can help you.

    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    Wednesday, March 19, 2014 3:55 PM