I have the doubt in date format

[sreekandan]

hi everybody, Now im doing one project.In that I have to insert the Date Of Birth field into the db table.For that, if anybody enter the DOB field,I have to check whether it is in the format of "DD/MM/YYYY" or not.I have written the code for that is If text1.text<>Format$(DD/MM/YYYY) Then
Msgbox"DOB Should Be The Format Of DD/MM/YYYY"
But it hasn't succeeded. So kindly reply me anyone quickly.

[sukeshchand]

Dear sreekandan,
i advice to use date fields in dd/MMM/yyyy format.....
because here lots of chance to make mistake in day and month positions

[sreekandan]

Dear sreekandan,
i advice to use date fields in dd/MMM/yyyy format.....
because here lots of chance to make mistake in day and month positions

i tried with that code.But i couldn't get the right output.So kindly anyone reply me.

[Killer42]

i tried with that code.But i couldn't get the right output.So kindly anyone reply me.

One thing you could try is If Not IsDate(text1.text) Then...

Of course, one problem you may run across in such cases is people mixing up the month and the day. That's where using a non-numeric month can be useful. For example, 01/02/2003 is quite ambiguous, where "01 FEB 2003" is much harder to misinterpet.

Another option is to use something like a Calendar or DateTimePicker or Masked Edit control, which only allows the user to enter a valid format.

[sreekandan]

One thing you could try is If Not IsDate(text1.text) Then...

Of course, one problem you may run across in such cases is people mixing up the month and the day. That's where using a non-numeric month can be useful. For example, 01/02/2003 is quite ambiguous, where "01 FEB 2003" is much harder to misinterpet.

Another option is to use something like a Calendar or DateTimePicker or Masked Edit control, which only allows the user to enter a valid format.

thanks.I tried with that code.So i got the proper output that what am i thought.

[sreekandan]

One thing you could try is If Not IsDate(text1.text) Then...

Of course, one problem you may run across in such cases is people mixing up the month and the day. That's where using a non-numeric month can be useful. For example, 01/02/2003 is quite ambiguous, where "01 FEB 2003" is much harder to misinterpet.

Another option is to use something like a Calendar or DateTimePicker or Masked Edit control, which only allows the user to enter a valid format.

If i want the format of "MM/DD/YYYY"
Then, how can I write change the above code you have given?

[hariharanmca]

If i want the format of "MM/DD/YYYY"
Then, how can I write change the above code you have given?

Better you give one lable at the top of the text1.Text with caption of the date format which you need then onely it will users friendly.... Ok