Date -7 Criteria

S

Stuart Evans

Hi
I am trying to make a criteria to list dates using a parameter value
box.
I have >=[WeekEnd Date] in my criteria this will list anything after date
entered ok, but if I add -7 onto end of this it will not list everything
from date entered minus 7 days all I get is a error saying(This expresion is
typed incorrectly or it is to complex)
 
J

Jeff Boyce

Stuart

The error message implies that the syntax needs work. Have you tried
placing the calculation (your date - 7) within parentheses?
 
Top