Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing dated material

Status
Not open for further replies.
ShaiBoo

ShaiBoo

Technical User
Mar 27, 2002
4
0
0
US
I'm running this queries that shows open records for the past 90 days. The only thing is that records past 90 days are still showing up but I need to eliminate them once they reach 91 days. Can anyone help?
 
Sort by date Sort by votes
You could use the dateadd function
eg
Dim a
a = Format(Date, "dd/mm/yy")
a = DateAdd("d", -91, a)


I've just tried this and it appears to work in 2000

regards

jo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

irethedo
  • Locked
  • Question
removing records from a continuous subform 1
Replies
2
Views
29
irethedo
irethedo
breezett93
  • Locked
  • Question
Removing individual records from form after query is run 1
Replies
16
Views
42
Andrzejek
Andrzejek
08211987
  • Locked
  • Question
Adding a bogus timestamp to existing dated field formatted as mm/dd/yyyy 2
Replies
7
Views
28
08211987
08211987
TJVFree
  • Locked
  • Question
Help Removing Duplicates record (is it my join?)
Replies
1
Views
14
dhookom
dhookom
Countymnca
  • Locked
  • Question
DateDiff and timer like functioning event 1
Replies
6
Views
36
Countymnca
Countymnca

Part and Inventory Search

Sponsor

Back
Top