i'm making a library database and if the user returned the book passed the due date given.i want to find the day difference and multiply that to a given fine amount.like this

daydiff = due_date_of_book - date_returned

fine_amount = daydiff * amount

thanks in advance

In MySQL you can use DATEDIFF, MSSQL supports it too.

thanks, and one question this may seem out topic for this thread but how can i get a data from the database send it to a textbox?

Am sure you find the answer in the forum for the language you are using.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.