F Frank Dulk Jul 22, 2003 #1 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?
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?
J John Vinson Jul 22, 2003 #2 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? Click to expand... Use a criterion of < DateAdd("d", -30, Date())
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? Click to expand... Use a criterion of < DateAdd("d", -30, Date())
K KARL Jul 22, 2003 #3 In the Field: row of the query put [YourDate] + 30 In the Criteria: row of the query put <Date()
J John Vinson Jul 23, 2003 #5 The two are not the same things? Click to expand... The two answers are simply two different ways of accomplishing the same thing.
The two are not the same things? Click to expand... The two answers are simply two different ways of accomplishing the same thing.
F Frank Dulk Jul 23, 2003 #6 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
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
J John Vinson Jul 23, 2003 #7 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? Click to expand... 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.
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? Click to expand... 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.
