Date parameter query Question 1

[quest4]

I have a question, I'm currently entering a start date and and end date, with defaults. This is the line:

Att.DateWeekStarting Between Nz([Enter Start Date],Date()-7) And Nz([Enter End Date],DateAdd("ww",-14,Date()))

I would like this to be reduced to entering only the start date and automatically set the end date to start date minus 13 weeks, reguardless of what date I put in as the starting date, the ending date will be 13 weeks less. Thanks in advance rto any one who helps.

 

[tomschafer]

Att.DateWeekStarting Between Nz([Enter Start Date],Date()-7) And Nz(DateAdd("ww", +13, [Enter Start Date]),DateAdd("ww",-14,Date()))

 

[quest4]

This generated a syntax error with a missing operator.

 

[quest4]

There must be some character in my line of code, after I retried this with cut and paste it woorked. Thanks a lot.