Date calculation

  • Thread starter Thread starter Guest
  • Start date Start date
John,

What is actually ended up doing is this for each criterion
=DateAdd("m",3,Date()) And <DateAdd("m",6,Date())
=DateAdd("m",6,Date()) And <DateAdd("m",12,Date()), etc.
Click to expand...

Thought I would give some feedback and let you know how I handled it. Thank
you for your help, you been great.
 
John said:
No.

The field Current_Requal_date should simply NOT EXIST in your table.

Don't store it *anywhere*. You can calculate it whenever it's needed,
either in a calculated field in a Query, or as the Control Source of a
textbox on a Form or Report.

The only exception to this would be if you want the date to *default*
to 6 months (or 30 months, or whatever) after the first date, but you
want to be able to edit that date freely to any other value. If that's
the case post back.

John W. Vinson[MVP]
Click to expand...
I am interested in being able to have a date set to default but also be
freely editable.
 
Back
Top