Date -7 Criteria

  • Thread starter Thread starter Stuart Evans
  • Start date Start date
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)
 
Stuart

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