•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Computer Science and Software Design section within the Software Development category of DaniWeb, a massive community of 391,616 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,629 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Computer Science and Software Design advertiser:
Views: 19683 | Replies: 2
 |
•
•
Join Date: Aug 2005
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi, I'm currently creating a database and need to create a query to show all the records that the warrenty date expires within the next week. i know this is a simple query as I did it when doing my A-Level in computer studies however I was working in a pub for the last year and am out of practise. So far I have simply put the criteria in the warrenty expiration date as ">=Now()+7" however that seem to be displaying the records with a date between now and 7 years from now. I hope someone can help me with this before I do too much damage to myself banging my head against my desk. thanks.
•
•
Join Date: Nov 2005
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
>=("d",7,int(now())) or >=("w",1,int(now()))
Had same problem.. kinda
Had same problem.. kinda
•
•
Join Date: May 2006
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by duubz
Hi, I'm currently creating a database and need to create a query to show all the records that the warrenty date expires within the next week. i know this is a simple query as I did it when doing my A-Level in computer studies however I was working in a pub for the last year and am out of practise. So far I have simply put the criteria in the warrenty expiration date as ">=Now()+7" however that seem to be displaying the records with a date between now and 7 years from now. I hope someone can help me with this before I do too much damage to myself banging my head against my desk. thanks.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Computer Science and Software Design Marketplace
Linear Mode
•
•
•
•
antivirus apple blog business c# code computer console dell design development erp systems firefox game google india internet ipod linux malware media microsoft mozilla networking news office open operating os pc programming project management science search security server software software selection source spyware survey system technology evaluation upgrade vista web windows xbox 360 xp zune
- Is it possible to display report in Visual Basic which is created in Microsoft Access (Visual Basic 4 / 5 / 6)
- I hava trouble with Microsoft Access database, Pls help me. (Java)
- Microsoft Access Format/Validation ??? (Windows Software)
- Microsoft Access Field Format ??? (Windows Software)
- Upgrading to Microsoft Access 2002 (MS Access and FileMaker Pro)
Other Threads in the Computer Science and Software Design Forum
- Previous Thread: im sorry this is off topic but want to know this
- Next Thread: round robin algorithm
