Date Input mask problem!

[atiq]

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.

 

[RoyVidar]

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

 

[neileg]

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.