Help! Filter query between date range

[hardrock]

Hi all, Please help me correct this criteria for a filter in my query.
I want to show all records between todays date and the past 14 days.
I've tried,

Between Date() and "Date - 14"

And it dont work. Thanks for any reply.

 

[PeterF]

Try:
Between Date() and Date() - 14 or
Between Date() and dateadd("d",-14,date())