<div>
If the date is indeed stored as a date in the database, you can do<br />
dim MyDate as string<br />
MyDate = Format(rs.fields(&quot;DBDateFi<wbr />eld&quot;), &quot;mm/dd Hh:Nn:Ss&quot;)<br />

</div>


If the date is indeed stored as a date in the database, you can do
dim MyDate as string
MyDate = Format(rs.fields("DBDateField"), "mm/dd Hh:Nn:Ss")


<div>
Perfect... thanks for the quick answer!
</div>


<div>
<div class="content wysiwyg-content">
I have a date/time value I'm reading from a database that returns the date/time in this format:<br />
May 01 16:17:32 2009 &nbsp; &nbsp;... I would like to convert this to a better format, such as this:<br />
05/01 16:17:32<br />
<br />
I don't see an easy way to do that in VB ... can someone help? &nbsp;Thanks.
</div>
</div>


I have a date/time value I'm reading from a database that returns the date/time in this format:
May 01 16:17:32 2009    ... I would like to convert this to a better format, such as this:
05/01 16:17:32

I don't see an easy way to do that in VB ... can someone help?  Thanks.

How to Convert MON DD HH:MM:SS YYYY Format in VB?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.