cant get query to take "ww" criteria

[pungentSapling]

I have a make table query that needs to only use the data that is dated the previous fiscal week to the current date. The field is in "yyww" format.

I can not seem to get this to work.
I tried the criteria datepart("ww",date())-1 with no success... I have even tried hard coding the criteria to a specific week and it wont work..........any suggestions

 

[raskew]

See if this will help:

? format(dateadd("ww", -1, date()), "yyww")