<div>
MsgBox Format(Now, &quot;hh:nn AM/PM mmmm dd, yyyy&quot;)
</div>


MsgBox Format(Now, "hh:nn AM/PM mmmm dd, yyyy")

<div>
<div class="content wysiwyg-content">
I am trying to format a label to display the date and time in the following format:<br />
<br />
ex. &nbsp;10:38 AM &nbsp; &nbsp; &nbsp;April 20, 2005<br />
<br />
If I use Now, it shows correctly, but the date includes the day of the week which I don't want. &nbsp;However, when I use HH:MM, I get a 24 hour format, so when in the PM, it shows hours greater than 12. &nbsp;What is the best way to format the date and time to get the above example. &nbsp;Thanks for the help.
</div>
</div>


I am trying to format a label to display the date and time in the following format:

ex.  10:38 AM      April 20, 2005

If I use Now, it shows correctly, but the date includes the day of the week which I don't want.  However, when I use HH:MM, I get a 24 hour format, so when in the PM, it shows hours greater than 12.  What is the best way to format the date and time to get the above example.  Thanks for the help.

Date and Time Formatting

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.