You need to sign in to do that
Don't have an account?
SL Tan
I am trying to put in a control formula for the date field where a user can only select a date that is on the same day the user is inputing the data or a day that is earlier but the user cannot select the next day or a date that is later. Does anyone try to do this before? If so, I would appreciate some advise on how to code for the formula in the date field. Any help will be highly appreciated. Thanks in advance
SL
Need advise on custom formula for Date Field
I am trying to put in a control formula for the date field where a user can only select a date that is on the same day the user is inputing the data or a day that is earlier but the user cannot select the next day or a date that is later. Does anyone try to do this before? If so, I would appreciate some advise on how to code for the formula in the date field. Any help will be highly appreciated. Thanks in advance
SL
All Answers
Thanks for your advise to use Validation Rule - this solves my problem - and thanks for the coding direction too
Best Regards
SL
Thanks for your post - it really helps! I am now able to solve all my date fields that need validation rules
Best Regards
SL