<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am using the following code in a standard module. From any form in my project<br />
I call the function with eg S = DateString(Me.DateTimePick<wbr />er1.Value.<wbr />Date)<br />
but the string comes back with eg &quot;2013-00-08&quot;. I am not sure why zeros appear for the month<br />
<br />
Function DateString(, ByVal oDate As Date) As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DateString = oDate.ToString(&quot;yyyy-mm-dd<wbr />&quot;)<br />
End Function
</div>
</div>


Hi

I am using the following code in a standard module. From any form in my project
I call the function with eg S = DateString(Me.DateTimePicker1.Value.Date)
but the string comes back with eg "2013-00-08". I am not sure why zeros appear for the month

Function DateString(, ByVal oDate As Date) As String
                DateString = oDate.ToString("yyyy-mm-dd")
End Function

VB.net issue with date format

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,