Make Due Date

[mobarak ahmed]

hi Dears ,
I have Date of invoice and collection Days i want to make Due date and statue of collection "Due or Not Due " and remaining days
for example:-
Date of invoice is 6/6/2021
number of Collection Days "30" days =6/7/2021
Due Date will be date of invoice + 30
statue of collection will be Due if date <6/7/2021 or Not Due if Date > 6/7/2021
Remaining Days will count down from 30 day
if anyone can help me and make it in file it will be apricated

 

[Gasman]

Look at the DateAdd() function for all of those requirements

 

[arnelgp]

better to visualize in a demo.
see Query1.
see also Term table.

 

[Gasman]

better to visualize in a demo.
see Query1.
see also Term table.

Isn't it due if date before due date?

 

[arnelgp]

Isn't it due if date before due date?

i think the OPs analysis is somewhat reciprocal?

 

[mobarak ahmed]

better to visualize in a demo.
see Query1.
see also Term table.

Many Thanks Dear