Limit user input to current date or newer

  • Thread starter Thread starter alaxmen
  • Start date Start date
A

alaxmen

I have a txt box called "PayOffDte" that requires user input for the
date which will be used to calculate a estimated loan payoff. However,
if the user uses a date older than current, it will still calculate the
amount and store the info. I want to stop the user from being able to
put in a date that is older than current/future date.
 
I have a txt box called "PayOffDte" that requires user input for the
date which will be used to calculate a estimated loan payoff.
However, if the user uses a date older than current, it will still
calculate the amount and store the info. I want to stop the user
from being able to put in a date that is older than current/future
date.
Click to expand...

Use a validation rule of...
 
I have a txt box called "PayOffDte" that requires user input for the
date which will be used to calculate a estimated loan payoff. However,
if the user uses a date older than current, it will still calculate the
amount and store the info. I want to stop the user from being able to
put in a date that is older than current/future date.
Click to expand...

Have a validation rule for the text box ">= Date()". You might further help
your users by having "Date()" as the default value.

HTH - Keith.
www.keithwilby.com
 
I have a txt box called "PayOffDte" that requires user input for the
date which will be used to calculate a estimated loan payoff. However,
if the user uses a date older than current, it will still calculate the
amount and store the info. I want to stop the user from being able to
put in a date that is older than current/future date.
Click to expand...


Thanks for the input everyone!!!!!! The suggestions worked very well.
I have also decided to set the default to the current date. Thanks
again....
 
So PayOffDte will NEVER be yesterday (or last business day or the day
before that) because the system went down and we could not enter this
information yesterday and are trying to catch up with work today?
 
Ron2006 said:
So PayOffDte will NEVER be yesterday (or last business day or the day
before that) because the system went down and we could not enter this
information yesterday and are trying to catch up with work today?
Click to expand...

That lesson is only ever learned the hard way ;-)
 
Back
Top