Home
|
Contact Us
|
FAQ
|
Search & Site Map
|
Link to Us
Sign In
|
Join
|
Other 45 Sites in Network
Home
Discussion Groups
Forms
Forms Programming
Queries
Modules / DAO / VBA
Reports / Printing
Macros
Database Design
Security
Conversion
Importing / Linking
SQL Server / ADP
Multiuser / Networking
Replication
Setup / Configuration
Developer Toolkits
ActiveX Controls
New Users
General 1
General 2
Access Directory
Tools
Tutorials
User Groups
Related Topics
SQL Server
Other DB Products
MS Office
More Topics ...
MS Access Forum
/
General 2
/
July 2007
Tip:
Looking for answers? Try searching our database.
Date Calculations
Thread view:
Tree View
List View (postings sorted by date)
Single Message View
Enable EMail Alerts
Start New Thread
Thread rating:
Kissi
- 16 Jul 2007 16:04 GMT
I have a shipdate field and want to run a query on dates that are 30 days or
more from shipdate to today's date. Can anyone help?
Reply to this Message
Ofer Cohen
- 16 Jul 2007 16:16 GMT
Under the field shipdate enter the criteria
<Date()-30
Or,
<DateAdd("d",-30,Date())
To return all the records that are older then 30 days or more from current
date
Signature
Good Luck
BS"D
> I have a shipdate field and want to run a query on dates that are 30 days or
> more from shipdate to today's date. Can anyone help?
Reply to this Message
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread
©2009 Advenet LLC
Privacy Policy
-
Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.