Actually I have records about 1000 credit customers,
My collection boys go to their door on due date(eg. 15-11-2016) for collection of money.
but they have no money to pay,that's why they call my collection boy after 10 day(eg. 26-11-2016).
I want the query in Sql.
if any customer give any other date,then my collection boy enter that date(26-11-2016) in application.and I want that,extended date get remind me on only that date(26-11-2016) which is entered by collection boy,not daily.
and after taking money the due date will remain(15-11-2016).
for next month collection.
I am unable to perform this operation in sql as well as other,so please help me out of this problem.