Date queries

[s-addicott]

i am trying to create a query that sorts arrival dates of bookings so that any customers booked in to arrive in the next week will appear.
my intial thought would be <Date()+7 however this lists the customers that are to arrive within the next week aswell as any customers that have arrived in the past.


my question is what would be an appropriate code to get all arrivals within the next week, but not arrivals that are in the past of the current date??

thanks

[Bob Fitz]

Maybe
>= Date() And <Date()+7

Or
> Date() And <Date()+7

[jzwp11]

It sounds like you need to have the dates from today to 1 week from today. BTW, it would be better to use the dateadd() function to add the 7 days. The criteria would look like this


WHERE yourdatefield BETWEEN date() and dateadd("d",7,date())

[s-addicott]

Maybe
>= Date() And <Date()+7

Or
> Date() And <Date()+7

YAY! works exactly how i needed it

thanks alot

[Bob Fitz]

Glad that worked for you, but I agree with jzwp11 that using DateAdd() function would be better