0

I am trying to pull times out of a mysql database and then convert them to the time of day using TimeFormat.

#TimeFormat(Recordset3.timeOne, "h:mm tt")#

My problem is once I add the "timeformat" all the times turn to 12AM regardless of what the time is in the database.

Thanks for any help :)

3
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by jedimatt
0

I think you have to use or capital HH for 24 hour

* h: Hours; no leading zero for single-digit hours (12-hour clock)
* hh: Hours; leading zero for single-digit hours (12-hour clock)
* H: Hours; no leading zero for single-digit hours (24-hour clock)
* HH: Hours; leading zero for single-digit hours (24-hour clock)
* m: Minutes; no leading zero for single-digit minutes
* mm: Minutes; a leading zero for single-digit minutes
* s: Seconds; no leading zero for single-digit seconds
* ss: Seconds; leading zero for single-digit seconds
* t: One-character time marker string, such as A or P
* tt: Multiple-character time marker string, such as AM or PM
* short
* medium
* long
* full

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.