I'm trying to define the Notice periods as below but to no avail.
Shall I have any suggestions as to how this can be achieved please...
=> Contract Start Date: 01/01/2010
=> Earliest termination date(contractee): 01/31/2013
=> Notice can only be sent between 4 to 6 months prior from earliest termination date.
Target simulation should look like this...
Recd From Receipt To Calcul. Notice
07/31/2012 09/30/2012 01/31/2013
08/01/2012 10/01/2012 02/01/2013
08/02/2012 10/02/2012 02/02/2013
08/03/2012 10/03/2012 02/03/2013
08/04/2012 10/04/2012 02/04/2013
And so forth And so forth And so forth
I have tried with all combinations in Expert Mode as well but of no avail.
Date Format: mm/dd/yy