Date and Time Formatting

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.
Who is Participating?
Format(Now, "hh:nn AM/PM MMMM DD,yyyy")
MsgBox Format(Now, "hh:nn AM/PM mmmm dd, yyyy")
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.