im a newbie developing a library management app, i need below functionality
1. Issued books and returned books details (date of issue,return) these details must be deleted automatically from issued books table automatically after 31 days.i want these details store only one month.
2.is there a way to calculate no. of days between dates accurately (feb 28.. ,leapyear issues) i want this to notify users how many days left to return book.