thx for your reply,
the biggest issue is how can i manage to display the information for 5 days.
have no clue how to do that?

oh sorry i'm bad at explaining, so this my issue:

i have a table that i fill with : ( n_file, and reception date, detail file, and final date ),
the only date that i receive is the (date_reception ) and if the (date_final) is not yet received ( because usually they send i paper with the this detail,
(file number, detail file, ..., final date).

if the final date is not received then a recall must be send mentioning...

Hello,
I writing a code that manages the deadlines of the files until now it was pretty simple they have only asked me to display the deadline of (n_file) one time after 10 days ( adddate to (reception_date )) and if = to date() the insertion is automatic in another table that contain ( N_file, deadline).

BUT yesterday I was asked:
while the (final_date) is empty the deadline date should be displayed every 10 days, and...