no later than date

  • Thread starter Thread starter peter
  • Start date Start date
P

peter

Hi I have a textbox and the formatting of it is ok but i
want to have the date validated as being today or earlier
so like <date() how do i do this?

thanks

peter
 
Hi Peter

In the Validation Rule of your text box enter >(Now()-1) .
Don't forget to set the validation message if it isn't a valid date.

Hope This Helps.
Larry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date as a value to a textbox as a result from another textbox 1
Excel Message box with days of month & date. 1
Access Dateadd function question.. 0
Access General Date Forced To Have Date And Time 2
Pivot table macro filter data between yesterday and today (date+time) 0
Validate Two Date Fields 10
Problem: textbox default value = Date() 3
Covid-19 Booster shot 6

Back
Top