Need to add 5 business days to a date field.

[malaisamy1]

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

[Deepak Kumar5]

Check your solution here

Setting a future date (business days only)

[malaisamy1]

Sorry guys,

Actually my requirement is,

we have two field, One is issue start date and another one is RCA due date.

for some condition,

RCA due date is 7 Business days from "Issue Start".

is there any solution for this scenario?

Thanks in advance.

Malaisamy

[Anurag Tripathi]

This is what you need

http://wiki.servicenow.com/?title=GlideDateTime#addDays.28int.29

var gdt = new GlideDateTime("2011-08-31 08:00:00");

gdt.addDays(7);

gs.print(gdt.getDate());

[malaisamy1]

Anurag,

while adding 7 days it has to exclude the Saturday and Sunday..

It has to add only business days.