G
Guest
In my table, I have a date field called Appointment Date which is used in the underlying parameter query
When the user enter a date it should show all dates between 7 to 15 days of the date the user entered
Ex: If the user entered 4/9/2004 it should show all Appointment dates between 4/16/2004 and 4/24/2004
I have tried this two formulas, but did not work… it gives me an error
BETWEEN DateAdd("d", 7, [Enter Date]) AND DateAdd("d", 15, [Enter Date]
Any suggestions..
When the user enter a date it should show all dates between 7 to 15 days of the date the user entered
Ex: If the user entered 4/9/2004 it should show all Appointment dates between 4/16/2004 and 4/24/2004
I have tried this two formulas, but did not work… it gives me an error
[enterdate]+6 And <[enterdate]+1
BETWEEN DateAdd("d", 7, [Enter Date]) AND DateAdd("d", 15, [Enter Date]
Any suggestions..