Date calculation

[Guest]

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.

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

 

[John Vinson]

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

Glad you got it working!

John W. Vinson[MVP]

 

[Tom]

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]

I am interested in being able to have a date set to default but also be
freely editable.