Skip to Content
Former Member
Jun 07, 2011 at 08:39 AM

Date Calculation in CRM service request



In the CRM service request creation, the requested end date is auto calculated based on the formula "current date + 3 days".

My issue here is, the formula "current date + 3 days" is calculated regardless whether it is public holidays or Sunday (non working days).

Example lets say todays date is 02.06.2011 (Thursday), the requested end date will be auto calculated as 05.06.2011 (which is Sunday).

Is there any way to determine the date profile to skip the Sunday or Public Holidays using the standard CRM?

For the example case above, the requested end date should be 06.06.2011 (Monday) -> Sunday should not be calculated.

Kindly please advise. Thank you.