<div>
Here is detailed article on that<br />
<br />
<a href="http://articles.techrepublic.com.com/5100-3513-6106789.html" rel="ugc">http://articles.techrepublic.com.com/5100-3513-6106789.html</a><br />
<br />
Hope it helps<br />
<br />
Thanks
</div>


Here is detailed article on that

http://articles.techrepublic.com.com/5100-3513-6106789.html [http://articles.techrepublic.com.com/5100-3513-6106789.html]

Hope it helps

Thanks

<div>
Thank you, however that only addresses the string, the conversion to Excel serial number isnt there<br />
unless Im missing something.<br />
<br />
Michal
</div>


Thank you, however that only addresses the string, the conversion to Excel serial number isnt there
unless Im missing something.

Michal

<div>
Convert it to date then to long and then to string.<br />
--<br />
JimFive
</div>


Convert it to date then to long and then to string.
--
JimFive

<div>
Try this<br />
<br />
DateTime.ToOADate &nbsp;- it returns double<br />
<br />
Then convert double to string.
</div>


Try this

DateTime.ToOADate  - it returns double

Then convert double to string.

<div>
That still does not give me the EXCEL SERIAL DATE NUMBER or does it ?
</div>


That still does not give me the EXCEL SERIAL DATE NUMBER or does it ?

<div>
Thank you<br />
<br />
Dim Adate as DateTime<br />
Dim a_date_string as string = &quot;13/08/2008&quot; (AU format)<br />
<br />
&nbsp;ADate = CDate(a_date_string)<br />
&nbsp;a_date_string = ADate.ToOADate.ToString 'Date
</div>


Thank you

Dim Adate as DateTime
Dim a_date_string as string = "13/08/2008" (AU format)

 ADate = CDate(a_date_string)
 a_date_string = ADate.ToOADate.ToString 'Date

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
In VB.net how do I convert a string &quot;dd/mm/yyyy&quot; into excel serial number as a string?<br />
The date is going back into a CSV file so the output will be text anyway.<br />
<br />
Thank you<br />
<br />
Michal
</div>
</div>


Hi,

In VB.net how do I convert a string "dd/mm/yyyy" into excel serial number as a string?
The date is going back into a CSV file so the output will be text anyway.

Thank you

Michal

Convert a string to Excel serial date number

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,