UtterAccess.com
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    
 
   
pglibra
post Dec 7 2017, 10:34 AM
Post#1



Posts: 8
Joined: 7-December 17



Hello,
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
PG
Go to the top of the page
 

Posts in this topic



Custom Search
RSSSearch   Top   Lo-Fi    15th December 2017 - 10:20 PM