What should I put in the criteria if I want the query to return a record that is 30 days from its Due date?
What should I put in the criteria if I want the query to return a record that is 30 days from its Due date?
<=date()-30
Didnt work. I have A "DateDue" Column in the query, I want it to show only records that are 30 days or greater from being due, i.e, if its 30 days from being due show it, or if its 1 day from being due or any day in between.
I tried what you suggested a few times....no workie.
I misunderstood.
try this: <= date() + 30 and >=date()
Didnt see your post until I had it figured out, what I used was
Date()>=[DateDue]-30
Does exactly what I need it to do.