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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dates that are 18 months old

Status
Not open for further replies.
bwedmund

bwedmund

Technical User
Oct 29, 2000
17
US
I have a database that is used for work. I need to have my database generate a report that shows dates that are 18 months or older.

thanks
Barry
 
Sort by date Sort by votes
You can use the DateDiff() function to determine the interval between Now() and the date you need to compare it to. You'll find it's syntax and usage under help.
 
Upvote 0 Downvote
Include records/rows where

[datefield]<=dateadd(&quot;m&quot;,-18,now())


Dave
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
231
atadbitslow
atadbitslow
qqp
  • Locked
  • Question
Need my msgbox that warns user of missing criteria to stop the rest of the code from running
Replies
2
Views
128
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Need help to migrate A2007 DB from old to new server 1
Replies
2
Views
96
TheresAlwaysAWay
TheresAlwaysAWay
blueman124
  • Locked
  • Question
All records not showing in access table that is linked to sharepoint list
Replies
0
Views
103
blueman124
blueman124
hudsma1
  • Locked
  • Question
how to make field value start with area code
Replies
2
Views
115
zandsc1
zandsc1

Part and Inventory Search

Sponsor

Back
Top