X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Number Data Type To Time Format, Access 2013    
post Dec 7 2017, 10:34 AM

Posts: 8
Joined: 7-December 17

I need help converting a number data type field to time format.
Our administrator has the field type locked down so I cannot change it from Number to Date/Time.
Currently, the Field is simply "UPDATE_TIME" and it returns, for example, 103826, which would translate into 10:38am and 26 seconds.
What expression format do I use to display outcome in time format (minus the seconds) and if possilble to show AM/PM? So simply 10:38am.

Thank you
Go to the top of the page

Posts in this topic

Custom Search
RSSSearch   Top   Lo-Fi    23rd October 2018 - 12:28 AM