If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to calculate days due?
I have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having a value of 30. I then take the difference between the ship date from the invoice and the paid date to calculate if they are paying within terms. Everything works well, but now there's a customer with terms of 6/1. How can I calculate if they are paying within terms when the number of days due changes everyday? Thanks Jim |
Thread Tools | |
Display Modes | |
|
|