Finding max due date

[sudhir0538]

Hello Community !

For a company it's issuing few items to employees. The data (stores) data is separated in different tables like employees table ,items table,issuing table and so on.. For every issuing item there's a life time and based on that due date is calculated field is present in data base. req is to identifying the max.due date and it to be compare with current date to identify it's status is due,not due,overdue.

As per the given picture for emp code F2641 for item beltweb the due date should be 05-06-2021 instead of 10-11-2016 and like wise for emp code f2631 for item beltweb the due date should be 26-06-2021 instead of 31-10-2016 but for emp code f2635 it should display like 05-06-2021 because it didnt issue second time.

Please help to get it right. either in script / in chart where to modify and how to modify ?

Thanx.