I have created table date of birth. I am using sql server 2000
When I hit submit all the controls in txt boxes are cleared.

I type in suppose "asdefer" instead of 01/02/1970. When i hit "save" button it gives me mismatch error. I dont understand why and how I can solve this problem. In my sql server date of birth is 1970-08-02 format. In my asp page when I try to type in asdfg. it gives me mismatch error. How will I solve this problem. Thanks I will appreciate your help.

Hey,

I don't understand the problem.... shouldn't you get an error if you type in asdfg into a textbox?????????

Brian

 Well I should get an error, I guess because in the database
the date of bith format is 1970-02-05. When I type "acdg"in textbox. There is a mismatch. I dont know how when user enters acdg in textbox inform the user that he has typed wrong. He has to type valid birthdate. I hope you understand my question.
Thanks
shoakat

He is trying to say that the entered format should not be allowed, i mean if ny user enters abcd, it should return some valid error message saying invalid entry kinda. He should be allowed to enter the DOB format in the specified format, I have a suggestion, why dont you put some text besides the text box indicating the Format of the DOB to the end users, say "Enter this format yyyy-mm-dd". This would help.
Another way is to put multiple select option where in any user will get three list boxes, one yyyy, second mm and the third dd.
Third option is, you can write Javascript code to check the correct entry. I hope that helps.

Regards

sinapra

Hey,

If you pass the date to a local variable, then with this variable remove the / or - in the date. use the IsNumeric function to check to see if it is a number. If not a valid number, there are unapproved textual characters in a date. Then you could say that there were text in the date.

You also have to count into the fact that what if you want the date in yyyy-mm-dd, and someone enters in 20004-30-8. That would be an incorrect date. With dates you would need to have a more detailed way of checking. You could also use Regular Expressions; they are pretty powerful.

Brian

Can any body write the code for validating year,month and date without
Validate before it is send to the server.

I am also validating the the firstName and lastName, to see whether the user has enterd the first and second name. If not Validate before it is send to the server. My code for this is as follows but it requires something more
<script language = javascript>
        function C(){
        var FirstName = (document.thisForm.txtFName.value);
        var LastName =(document.thisForm.txtLName.value);
        if (FirstName=="" ||LastName=="")
        alert(" You have not entered the Last and FirstName");
       }

      </script>

Take a look at this. There are a lot of such code on the net for validation.

Date Validation

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

I am sure that would help Shoakat, the link suggested by Vijay, else he can build his own in ASP as suggested by brian since its good to have valid entry else it would bring some problems in date calculations.

Regards

sinapra