Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extract Time out of DateTime Type

Status
Not open for further replies.
Yogeetarp

Yogeetarp

Programmer
Jun 7, 2006
10
US
I want to extract the Time (12-hour type, NOT military) from a DateTime type for the display. I was thinking about displaying it as string and formatting it. But am having some problems in this transaction.

Any help or suggestions will be greatly appreciated.
 
Sort by date Sort by votes
Thanks for looking at it. This worked:

MyStr = Format(MyDateTime, "hh:mm tt")
' Returns "05:04:23 PM".
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
get controll type, controll name from the second panel of SStab 1
Replies
4
Views
662
strongm
strongm
2009luca
  • Locked
  • Question
population of italy live/real time
Replies
11
Views
452
strongm
strongm
Ken01
  • Locked
  • Question
Extraction of Picture box point / pixel colors. 3
Replies
13
Views
2K
klima
K
R_a_i_n_e_r_8
  • Locked
  • Question
Compile error: Types of intolerance (need help)
Replies
3
Views
719
strongm
strongm
2009luca
  • Locked
  • Question
CHECK color of shape 2
Replies
5
Views
382
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top