Normalize - dates, how to connect?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am revamping a database to normalize the dates so that I can report on the
most recent due date for each record. It is my understanding that I need one
date field.

I have set up a table with Date_Category (Action, Due or Reminder) and
Date_Type (there are 23 types). Each Due Date has a calculated Reminder
Date (when to send the reminder out). Some of them have an Action Date
(which is a date that we would have made a request, or notified.

What I need is to be able to report where the most recent due date will
print with information regarding the action and the date that the reminder
should be sent out. (there are other non-date fields in the Main Table). I'm
struggling with how to get the correct action and reminder tied into the
right due date. I'm wondering if I need more tables?

Thanks very much!
 
Do different types have different due date criteria? Like Non-Payment due
10 days after end of month - Request for receipt conformation due 15 days
after shippment - etc.
 
Hi Karl, I guess they do have different criteria. Some due dates have set
time frames (ie. we receive notice and have 30 days to respond). Others, we
request an extension for example, and are given a set due date (not
necessarily based on a certain number of days)
 
Please post your table structures.

carrietom said:
Hi Karl, I guess they do have different criteria. Some due dates have set
time frames (ie. we receive notice and have 30 days to respond). Others, we
request an extension for example, and are given a set due date (not
necessarily based on a certain number of days)
Click to expand...
 
Back
Top