Help! Validation Rule and Text

[greeneyerat]

Hi,

I have been trying to create a validation rule for a date field in the following format:

dd-mmm-yy

I have been unsuccessful. Any ideas for the validation rule?

Thank you in advance.

 

[r937]

what database?

many of them have functions like SQL Server's ISDATE() which will do the validation for you

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)