F
Frank Dulk
How do I do in a query to show only the records that have the date + 30 days
that are smaller than the current date?
that are smaller than the current date?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
How do I do in a query to show only the records that have the date + 30 days
that are smaller than the current date?
Use a criterion of
< DateAdd("d", -30, Date())
K
KARL
In the Field: row of the query put [YourDate] + 30
In the Criteria: row of the query put <Date()
In the Criteria: row of the query put <Date()
F
Frank Dulk
The two are not the same things?
J
John Vinson
The two are not the same things?
The two answers are simply two different ways of accomplishing the
same thing.
F
Frank Dulk
But sees that yours not this adding 30 days in the typed date:
would have to be:
MyDate + 30 <Dates ()
Does your example make that?
Excuse my question, but my knowledge are few
would have to be:
MyDate + 30 <Dates ()
Does your example make that?
Excuse my question, but my knowledge are few
J
John Vinson
But sees that yours not this adding 30 days in the typed date:
would have to be:
MyDate + 30 <Dates ()
Does your example make that?
Mine is
Mydate < Date() - 30
It is simple algebra; the one expression adds 30 to MyDate before
comparing, the other subtracts 30 from Date before comparing.