<div>
Hi TimSweet220,<br />
<br />
do you want to check the format or check the date is valid?<br />
<br />
you could just check it is valid and then strip it into the format you want:<br />
<br />
If IsDate(strDate) then<br />
&nbsp; &nbsp; //Do something<br />
Else<br />
&nbsp; &nbsp;//not valid date<br />
End If<br />
<br />
<br />
Apresto
</div>


Hi TimSweet220,

do you want to check the format or check the date is valid?

you could just check it is valid and then strip it into the format you want:

If IsDate(strDate) then
    //Do something
Else
   //not valid date
End If


Apresto

<div>
the universally accepted date format is yyyy/mm/dd, i would recommend you use that format
</div>


the universally accepted date format is yyyy/mm/dd, i would recommend you use that format

<div>
<div class="content wysiwyg-content">
What is the best way to check for formatting of dates in a vb form before it get send to the db?<br />
<br />
I was considering the text change on the field, but not sure that's the best way.<br />
<br />
Code sample would be great.<br />
<br />
Thanks in advance.<br />
<br />
Tim
</div>
</div>


What is the best way to check for formatting of dates in a vb form before it get send to the db?

I was considering the text change on the field, but not sure that's the best way.

Code sample would be great.

Thanks in advance.

Tim

Check Date formats before updating database

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,