Date Queries

  • Thread starter Thread starter Guest
  • Start date Start date
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
How could I do this

Thanks in advance!!
 
In the criteria for the AppointmentDate field, enter:
[enterdate]+6 And <[enterdate]+16
Click to expand...

Before this will work, right-click in the area where your tables are shown.
select "parameters" and enter the following:

Parameter Data Type
enterdate Date/Time



Rick

Shaji said:
In my table, I have a date field called Appointment Date which is used in
Click to expand...
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
Click to expand...
between 4/16/2004 and 4/24/2004.
 
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.
How could I do this?

Thanks in advance!!!
Click to expand...

BETWEEN DateAdd("d", 7, Date()) AND DateAdd("d", 15, Date())

as a criterion.
 
Back
Top