Validating Dates

If you have dates that you wish to validate as per the scenario below:

1. 16/09/06 - 30/09/06 only

2. 1/10/06 - 30/10/06 only

Solution Below:

For a table, place your cursor in the field you wish to validate. At the bottom you will see 'Field Properties'. Next to 'Validate', type the following:

Between #16/09/2006# And #31/10/2006#

Then, write a message in the Validation text, this text will appear if the date is wrong.

The two date ranges above are sequential so you only need one validation statement, if the two dates were separate periods of time then it would be written as:

Between #1/09/2006# And #31/10/2006# Or Between #1/12/2006# And #31/12/2006#


Share this page: