Calculating Formulate for dates

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

Guest

I am creating a student attendance table:
Start date Field 05/01/2004. I wish to create a formulae in the table that will automatically calculate 7 days from the start date and insert the calculated date in the Week2Date Field.

Can this be done in the design view of the table? Any suggestions of the simplest method(s) on how it can be achieved would be greatly appreciated.

Mike K
 
I wish to create a formulae in the table that will automatically
calculate 7 days from the start date and insert the calculated date in
the Week2Date Field.
Click to expand...

No you don't.

You want to create a query that will display the calculated date: put this
in the top line of a new query grid:

WeekTwoDate: DateAdd("w",1, [StartDate])

Hope that helps


Tim F
 
Back
Top