Set up Due Date

[Hank]

I am trying to set up a table showing payment due dates. The due date of
the 1st payment will be the first Friday following the StartDate and each
Friday thereafter - Until StopDate. Exceptions would be when we are closed
for Christmas, Spring Break, etc.

Now my table has the following fields:
PaymentID (autoNumber)
DueDate - For now I manually enter the due date (takes a while)
PmtDate - Date the payment was received.
Notes - Misc Text field
ContactID - Linked to list from the student table.

Possible new fields would be:
StartDate:
StopDate:
PastDueAmt: - to alert me when payments are not made after 2 weeks.

Any help to start me in the right direction would be appreciated.
Hank

 

[Guest]

Hi Hank,

You can use the DateAdd function to add 7 days to your start date, but you
will need to create your own table containing all dates that you are closed,
or open, and then refer to that, to 'bump' the date forwards, or backwards by
a given number of days.

Do a search in these forums for holiday dates or similar and you will find
various functions and codes that should help you put together what you need,
by picking and choosing the most appropriate parts for you.

hope that helps,

TonyT..