due date

[ahsan4]

I wanted to ask everyone for their advise on a requirement I am working with and I wanted to know what the best practice/method of developing this fuctionality would be.   Customer wants to have a field that will be used to display at form/list view a field that shows how many days from the due date are left.   Than each day that the request is not fulfilled it goes down from ex: 7 to 6 to 5 to 4 (they actually want it to turn red once it is 1 or less and also start going in to negative numbers as the due date is pas due).  

Where I am not sure how to go about this is because the they have one workflow for this one process but the catalog items are 20 + items that all have a different due dates.   Right now, they have not developed a due date solution and they are using the default that shows one day for all the items.

Questions are :

1) How do I apply multiple due dates to multiple items when the are using a single workflow?

2) How do I take the due date field and create another field on the Req to display in days and decrease into negatives

Thank you

[ghsrikanth · Accepted solution]

Hi Syed,

Please check the wiki link to calculate due date on any table, may be you can explore the option of defining calculation on due date on the catalog item request -

Using DurationCalculator To Calculate a Due Date - ServiceNow Wiki

Section 5

Mark if it is correct or helpful, feedback is appreciated

[ahsan4]

Hi Skrikanth,

Thank you for the reply.   I am comfortable with this portion of it and have this wiki pulled up already but I guess, I was seeking guidence in what my customer was trying to do.   Right now, they are defaulting to 1 day due date expiration.   If I change that on the workflow they are using it, it will be the same for all their items.   Their process has one workflow that it is using but I am not sure how I proceed with modifing due dates in the best way for each item.

[ghsrikanth]

I feel the best way is to redesign and each catalog item request has its own workflow but the parent record will end only after all the subsequent child records closed.

[ahsan4]

ok so that makes me feel a lot better because I assumed that but the customer is against that at the moment.   If I build a new table (due date table) and add Item, description, due date and track/maintain all the items on the table, could that be a work around (not best practice I understand) to extend that to the request? Thank you for helping, I am just stuck in a tough place due to what I am being allowed to do.

thank you