previous dates

[wort0987654321]

i have a booking system and i want to see all of the bookings that where made in the previous 2 weeks (14 days). at the minute i am entering <=Date()-14 into the criteria box under date, this doesnt seem to work, all it does is bring up bookings that where made on the date 14 days after todays date and not any of the bookings inbetween the dates.
please help
thank-you

 

[Mile-O]

Between DateAdd("d", -14, Date()) And Date()

Or;

Between Date() - 14 And Date()

Or;

>= Date() - 14

Or;


>= DateAdd("d", -14, Date())