show only the records that have the date + 30 days

[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?

 

[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())

 

[KARL]

In the Field: row of the query put [YourDate] + 30

In the Criteria: row of the query put <Date()

 

[Frank Dulk]

The two are not the same things?

 

[John Vinson]

The two are not the same things?

The two answers are simply two different ways of accomplishing the
same thing.

 

[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

 

[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.