displaying deadline each 10 days

[ana87]

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 on top of that STAYING displayed for 5 days, HOW can i manage that seriously.

[NeoPa]

Without knowing what you mean by a file's deadline date none of this makes any sense to me.

Perhaps you could review the question and write it in such a way as to make sense to those of us that don't already know what you want.

[ana87]

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 (N_file) where the (final date) is messing.

that's why a query should be done to follow the whole recall process.

so the (date_final) is null until the reception of the paper,
the (n_file) should be displayed after each 10 days. to send a recall to send us the information.

i donno what to do?
how to calcul the interval??
there is no date end, because the date end is the day when the (file is received with date_final).???

hope i'm more clear?

[NeoPa]

It's easy enough to find all records where [Date_Final] is Null and [Date_Reception] is ten or more days old :

SELECT *
FROM   [YourTable]
WHERE  ([Date_Final] Is Null)
  AND  ([Date_Reception]<DateAdd('d',-10,Date()))

What makes this difficult is that you want it every ten days from [Date_Reception] until [Date_Final] is set, yet you don't have any way of holding which multiples of ten days have already been shown, so don't need to be shown again. Without that I don't see your requirement as possible.

[ana87]

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?

[NeoPa]

Again, you're not explaining what you want very well. Please specify precisely what you mean when you say for five days. Five days from when?

It's going to be very difficult for you, or anyone else for that matter, to find a solution to a problem when you haven't even worked out what that problem is. Once you've determined exactly what you want then it will be much easier - not only for us but also for yourself - to think about solutions.

[zmbd]

also, what information do you want displayed for 5 days?