Date Paramater projected out 18 months

M

Michelle

Hi I would like my users to enter two dates for example.
Enter Start Date: 2/7/2006
Enter End Date: 2/28/2006
however I want the resolts to give you the start date and end date projected
out 18 months so basicly it would return the records between 8/7/2007 to
8/28/2007.
This is what I tried but it does not work.
Between DateAdd('m',+18,Date()) And DateAdd('m',+18,Date())
 
J

Jerry Whittle

Your use of DateAdd is just a little off.

DateAdd("m",18,Date())

m needs double quotes. You don't really need the + sign. Also your Between
statement won't return anything as both sides are the same. Assuming a
parameter query, you need is something like:

Between DateAdd('m',+18,[Enter Start Date]) And DateAdd('m',+18,[Enter End
Date])
 
Top