I have used 00/00/00;_ as an input mask for the date. the format of the date is Short Date.

The problem that i am facing is when i type the invalid date 29/02/07 to test whether it rejects it! it accepts the date and automatically changes the date to 07/02/2029 which is wrong. can someone help me sort this problem. any help would be much appreciated.

This is how it works, I'm afraid. Check out Allen Brownes explanations here http://allenbrowne.com/ser-36.html (#1).

There are some approaches, where one is either use some code, or validation rule, whatever is more appropriate, to detect dates "far off", and give the user a message or disallow saving.

Another could be to use some kind of date picker - there should be several "floating around" the net ;)

Just though I'd add to Roy-Vidar's post.

This is the usual US/UK date format conflict. Using a medium date like 28-Feb-2007 will avoid this.