Parameter date equation

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

Guest

In the criteria section of a date record I want it to create a parameter
between two dates. I have input the simple equation:

Between [Enter Start Date] AND [Enter End Date]

How can I get the second field to generate automatically generate 14 days
from the first date entered? I want [Enter End Date] to equal [Enter Start
Date] +14
 
Between [Enter Start Date] And DateAdd("d",15,[Enter Start Date])
Thanks, just figured it out off of an older posting, but I do greatly
appreciate the help.

Van T. Dinh said:
BETWEEN [Enter Start Date]
AND DateAdd("d", 14, [Enter Start Date])

--
HTH
Van T. Dinh
MVP (Access)



dogpigfish said:
In the criteria section of a date record I want it to create a parameter
between two dates. I have input the simple equation:

Between [Enter Start Date] AND [Enter End Date]

How can I get the second field to generate automatically generate 14 days
from the first date entered? I want [Enter End Date] to equal [Enter Start
Date] +14
Click to expand...
Click to expand...
 
Back
Top