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 :)