HH:MM AM/PM Datetime format?

[BeanDog]

I want to have my time data displayed like this:
12:30 AM
When I convert to default datetime format, it looks like:
12:30:00 AM
When I convert to short datetime format, it looks like:
00:30 AM

How can I get 12:30 AM?



~BenDilts( void );

~BenDilts( void );
benbeandogdilts@cs.com

http://www.geocities.com/benbeandogdilts

Long-time BASIC game programmer, Internet programmer and C++/DirectX of late.

 

[alkhemist]

Use the format command:

eg.

Datevalue = 02/19/2001 03:45:34 PM

formated:
Format(Datevalue, "mm/dd/yyyy hh:nn AM/PM&quot
gives: 02/19/2001 03:45 PM

Format(Datevalue, "m/d/yy hh:nn AM/PM&quot
gives: 2/19/01 03:45 PM


Format(Datevalue, "m/d/yy hh:nn&quot
gives: 2/19/01 15:45