Need to add 5 business days to a date field.

malaisamy1 · ‎11-15-2016

Hi Guys,

I have a scenario where i need to add 5 business days to a date field. while adding 5 days it has to exclude the Saturday and Sunday.

Note: This is a date field. not a date and time.

Is there any solution?.. Please help me on this.

Thanks in advance.

Malaisamy J

prajaktanaik · ‎11-15-2016

Hi Malaisamy,

Please replace the line var issueStartDate = current.issueStartDate.getGlideObject(); with below:

var issueStartDate = new GlideDateTime(current.issue_start);

Let me know, if this helps.

Regards,

Prajakta

PS - Please mark Helpful, Like, or Correct Answer if applicable.

malaisamy1 · ‎11-15-2016

Hi Naik,

Its amazing.. It works perfectly fine.

Thank you so much.

Malaisamy J

manali25 · ‎06-29-2017

On which table i am suppose to write this Business rule and it should run when??

Anurag Tripathi · ‎06-30-2017

Same table where you have to perform this operation, same where your date field is.

-Anurag

manali25 · ‎07-02-2017

My date field is present on my catalog,it's a variable to be precise .

Anurag Tripathi · ‎07-03-2017

Check this out, you'll get the code here

-Anurag