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]

Good luck man.

[Rushit Patel2]

Hi,

can you please share what did you finally implement? did you create a custom table to maintain duedate for items ?

Thanks