Filter Show all records between yesterday and -14

[Carl_R]

Having a bad hair day with a filter.

Currently, I have a filter that shows all records with yesterdays date:

Me.tblChanges.Form.Filter = "((OpenedDate=date()-1))"

This works fine... but now the user would like to see all records between yesterday and the previous 14 days (ugh!).

Any assistance greatly appreciated.

 

[namliam]

"[OpenedDate]<=date()-1 and [OpenedDate]>=Date()-1-14"
or
"[OpenedDate]<=date()-1 and [OpenedDate]>=Date()-14"

Depending on what you want exactly...

You can also use (i think)
"[OpenedDate] between ... and ..."

BR

 

[Carl_R]

"[OpenedDate]<=date()-1 and [OpenedDate]>=Date()-1-14"
or
"[OpenedDate]<=date()-1 and [OpenedDate]>=Date()-14"

Depending on what you want exactly...

You can also use (i think)
"[OpenedDate] between ... and ..."

BR

That did it! Thanks Mailman.
(syntax gets me every time)