less than date (1 Viewer)

[kitty77]

I'm working with a datesent field in a query. I do not want records from today and less than 14 days.
So, I don't want to see records from 3/18/22 to 4/1/22

Not Date()-14 like this?

 

[arnelgp]

... Where dateSent< Date()-14

 

[kitty77]

Damn, thought I tried that. Thanks!