| | |
Microsoft Access date validation
Please support our Computer Science advertiser: Learn about neural networks and artificial intelligence.
![]() |
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.
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.
![]() |
Similar Threads
- 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)
- Microsoft Access date validation Need a solution (Database Design)
Other Threads in the Computer Science Forum
- Previous Thread: relation of mathematics with computer science
- Next Thread: Help on SAS code
| Thread Tools | Search this Thread |
ai algorithm algorithms amazon assignment assignmenthelp assignments automata battery bigbrother binary bittorrent bizarre bletchleypark blogging bomb business cern codebreaker compiler computer computers computerscience computertrackingsoftware connect conversion csc dataanalysis dataintepretation development dfa dissertation dissertations dissertationthesis dissertationtopic ebook employment energy floatingpoint foreclosure foreclosuresoftware fuel gadgets geeks givemetehcodez government hardware history homeworkassignment homeworkhelp humor ibm idea ideas internet iphone ipod itcontracts jobs kindle laser laws linkbait lsmeans mainframes marketing mobileapplication nano netbeans networking news os p2p piracy piratebay principles programming rasterizer research sam-being-cute sas science security sex simulation software spying stephenfry study supercomputer supercomputing sweden technology textfield turing turingtest two'scompliment uk virus ww2






