•
•
•
•
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 426,910 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,291 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: Programming Forums
Views: 16940 | Replies: 5
 |
•
•
Join Date: Feb 2005
Location: England
Posts: 91
Reputation: 
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
Im using the validation rule ">=(Now())" to ensure the date entered in the field is today onwards only. However, this rule does not allow todays date to be entered. How can i get it to accept todays date but not previous dates?
This is part of my a-level coursework, so if you can help me it would be great...
cheers.
This is part of my a-level coursework, so if you can help me it would be great...
cheers.
•
•
Join Date: Dec 2004
Location: Lincoln Park, Michigan
Posts: 1,744
Reputation:
Rep Power: 7
Solved Threads: 108
send me the database?
•
•
Join Date: Feb 2005
Location: England
Posts: 91
Reputation:
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
i tryed using ">=Now()-1" it works but now when i run a query for todays date it cannot find anything!!! AAAHHH
•
•
Join Date: Feb 2005
Location: 55 26'N 118 46'W
Posts: 184
Reputation:
Rep Power: 4
Solved Threads: 13
Junior Poster
In Access, VB & Excel today is 38,427 days since Jan 1, 1970. The time becomes the fracation protion, so at the time I'm writing this response it's 38,427.31. Now at 3:30 pm today 38,427.65 you lanuch you application and try to enter data that was for ealier today it won't work because >=now ().
chang your formula to >= int(now()) and it will work fine.
chang your formula to >= int(now()) and it will work fine.
•
•
Join Date: Feb 2005
Location: England
Posts: 91
Reputation:
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
•
•
•
•
Originally Posted by Tight_Coder_Ex
chang your formula to >= int(now()) and it will work fine.
Cheers mate, it works a treat. Ive been struggling with that for ages, thats a great help...
|
•
•
•
•
•
•
•
•
DaniWeb Computer Science and Software Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
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
- Microsoft Access 2003 Validation Rule (MS Access and FileMaker Pro)
- Microsoft Access Format/Validation ??? (Windows Software)
- Microsoft Access date validation Need a solution (Computer Science and Software Design)
- Microsoft Access date validation Need a solution (Database Design)
Other Threads in the Computer Science and Software Design Forum
- Previous Thread: relation of mathematics with computer science
- Next Thread: Help on SAS code
