Automatic Dates

[andrewneal]

I am building an employee performance report database. Part of this report I need to integrate initial and midterm feedback dates. These dates are as such:

The initial is 30 days after supervision started or annual performance report completed
The midterm is 120 after supervision started or annual performance report completed

I'd like to give the supervisor a set month for their feedback completions as a guidline. If they are a few days prior or after the "30 day or 120 day mark" it is not a big deal, so I am just wanting it to automatically calculate the month rather than a specific day. After a performance report is completed the intial and midterm feilds should automatically update to calculate the new feedback dates for the next year.

The most updated dates need to be available for supervisors to print on a master report on all their subordinates. No need to store older dates (unless the performance report has not been completed yet)

Pertinent Info:

Form: Perf_Report
Table: Rater_tbl
Field Name 1: Initial ::: (format = mmmm)
Field Name 2: Midterm ::: (format = mmmm)
Field Name 3: Date of Supervision ::: (format = dd mmm yyyy)
Field Name 4: Report Completion ::: (format = dd mmm yyyy)

I am struggling to get this one off the ground and any help would be much appreciated!

 

[RuralGuy]

It is important that you not store these calculated date in your table. You can calculate them in a query with the DateAdd() finction and displaying them is simply a Format() function.