[aryhant]

Given a scenario that when the police issue a summon ticket to vehicle owner on 1st March 2012, if vehicle owner did not pay the summon within 7 working days the system must trigger a 1st reminder notification sms to vehicle owner on 8th day from the date of the summon issued.
Vehicle owner is given another 7 working days before a final reminder notification sms will trigger on the 8th day start from the from the 1st reminder notification sms date if vehicle owner did not pay the summon ticket and the vehicle owner will be blacklisted.
Vehicle owner can request for extension of additional 7 working days to settle the summon ticket within the period from summon issued date to before the Final reminder notification sms is triggered.

*working day exclude Saturday and Sunday.


If vehicle owner request for extension 7 days on 15th March 2012 after the 1st reminder notification sms is trigger the Final reminder notification sms will trigger on 30 March 2012 if user did not pay after the extension request and 7 working days after the 1st reminder is triggered.

1.Please provide the formula to calculate the first reminder sms date & Final reminder date base on the summon issued date as 1st March 2012 without extension request by the vehicle owner.

2.Please provide the formula to calculate the final reminder sms date base on the summon issued date as 1st March 2012 with extension request by the vehicle owner on 15th March 2012 after the first reminder notification is triggered.

[Stratmando]

I don't know of a "Formula"?
I would use a Calendar and do Visually, you can count days and easily not count weekends.