date difference question

[joe31709]

I want to build a query that when I put in a date like today for example it will go back 2 weeks and list all the infom from a table.

any ideas

 

[namliam]

Use: Between #[Give a date]# -14 and #[Give a date]#

This will allow the user to enter the date. I fyou want to always use todays date then use:Between date() -14 and date()

Regards

The Mailman

 

[joe31709]

Thank you,