User Name Password Register
DaniWeb IT Discussion Community
All
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
Reply
Join Date: Feb 2005
Location: England
Posts: 91
Reputation: NuGG is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
NuGG's Avatar
NuGG NuGG is offline Offline
Junior Poster in Training

Microsoft Access date validation

  #1  
Mar 15th, 2005
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.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Dec 2004
Location: Lincoln Park, Michigan
Posts: 1,744
Reputation: Comatose is an unknown quantity at this point 
Rep Power: 7
Solved Threads: 108
Colleague
Comatose's Avatar
Comatose Comatose is offline Offline
Moderator

Re: Microsoft Access date validation

  #2  
Mar 15th, 2005
send me the database?
Reply With Quote  
Join Date: Feb 2005
Location: England
Posts: 91
Reputation: NuGG is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
NuGG's Avatar
NuGG NuGG is offline Offline
Junior Poster in Training

Re: Microsoft Access date validation

  #3  
Mar 15th, 2005
i tryed using ">=Now()-1" it works but now when i run a query for todays date it cannot find anything!!! AAAHHH
Reply With Quote  
Join Date: Feb 2005
Location: 55 26'N 118 46'W
Posts: 184
Reputation: Tight_Coder_Ex is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 13
Tight_Coder_Ex's Avatar
Tight_Coder_Ex Tight_Coder_Ex is offline Offline
Junior Poster

Re: Microsoft Access date validation

  #4  
Mar 16th, 2005
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.
Reply With Quote  
Join Date: Feb 2005
Location: England
Posts: 91
Reputation: NuGG is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
NuGG's Avatar
NuGG NuGG is offline Offline
Junior Poster in Training

Re: Microsoft Access date validation

  #5  
Mar 16th, 2005
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...
Reply With Quote  
Join Date: Jun 2005
Posts: 12
Reputation: relawson is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
relawson relawson is offline Offline
Newbie Poster

Re: Microsoft Access date validation

  #6  
Jun 11th, 2005
Originally Posted by NuGG
Cheers mate, it works a treat. Ive been struggling with that for ages, thats a great help...

Another great "feature" brought to you by Microsoft :-)
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Computer Science and Software Design Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Computer Science and Software Design Forum

All times are GMT -4. The time now is 11:26 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC