help

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

How do you do a search based on date, for example I have a database,
which is log shipping contacts. How can I search for all entrys logged
which are 6 months old.
 
All you need is

YourDate < dateAdd("m",-6,Now)

' Where "m" stands for month

Hope this help,
Saran.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill not working 2
Select Subquery: To only display one year at a time 11
Access Need help in making asset history in my current database. 1
Excel Vba to change displayed year automatically. 14
Amazon Login Location Different 4
Multiple Dates in a table 1
DATE HELP 1
Muliple Critera 1

Back
Top