What does "6/1" mean with respect to terms? I have no idea how to interpret
what that means with respect to your post. Help us understand how it's to be
interpreted.
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"Jim" wrote in message
...
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