Date picker

[thedeadzeds]

Hi Guys,

I wonder if you can help. Is there a way to only allow users to select todays date or future dates in a date picker. I do not want any users to be able to change the date prior to today?

many thanks
Craig

 

[CJ_London]

not unless you write your own datepicker..

but you can set the validation rule to not accept a day earlier than today

 

[thedeadzeds]

Thanks, that would work, any idea how I do that?

 

[CJ_London]

either in your control properties or the table properties and in the validation rule put

>=Date()

and in the Validation text put

Must be today or later

or other suitable message

 

[ntyler1]

Thanks for the tip. Also looking to do this.