So my data currently comes in with a date, this is the date that the complaint is recieved
11/12/15
24hrs from this date there is a deadline that must be met, if it is met in the 3D COMPLETE feild there will be a date so for example
11/13/15
then , each customer has their own amount of time from the original complaint date say this customer has 15 days, so D5 must be complete by
11/27/15
If we are past this date it needs to show overdue, and if possible how many days overdue, then if that is completed within its window it moves onto d8 and for d8 it has to be complted within 30 days of the original complaint date,
so 12/12/2015
if that is not completed within that time, it must say overdue.
Is there a way that I can code this into my load script, or into a master item? I would love some help with this!
I have created some look up tables in the case that I need them, I also have attatched a sample of my data.
Thanks
Ariana