G
Guest
How can write a delete query to delete records in a table where the Date
field formatted 1/15/04 is older than 1 yr. from today? Thanks
field formatted 1/15/04 is older than 1 yr. from today? Thanks
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.
G
Guest
Save your data first, there will be no return
try this
DELETE TableName.*
FROM TableName
WHERE TableName.DateFieldName<DateAdd("yyyy",-1,Date())
try this
DELETE TableName.*
FROM TableName
WHERE TableName.DateFieldName<DateAdd("yyyy",-1,Date())
J
Jeff Boyce
"Why?" Why do you want to delete records older than 1 year?
Is your database experiencing performance issues? Are you trying to create
separate databases for each year?
You've asked "how" to do something. Can you describe the underlying
business need?
Regards
Jeff Boyce
<Office/Access MVP>
Is your database experiencing performance issues? Are you trying to create
separate databases for each year?
You've asked "how" to do something. Can you describe the underlying
business need?
Regards
Jeff Boyce
<Office/Access MVP>
G
Guest
How about dates 15 days old?
And how about today's records?
And how about today's records?
J
John Vinson
How about dates 15 days old?
A criterion of
< DateAdd("d", -15, Date())
will return all records where the datefield upon which you use the
criterion is older than 15 days ago.
And how about today's records?
=Date()
Open the VBA editor by typing Ctrl-G (to get to the proper Help file)
and take a look at the online help for DateAdd and DateDiff.
John W. Vinson[MVP]