I am having trouble with trying to format my data into a time column. currently, my database returns and time value of ex: 0538AM meaning 5:38 AM. i am doing an analysis based on time and i need to convert my data into somthing that is usable, preferably in the form of hh:mm.
I have tried using the following functions: time, time#, num#, num, timestamp, and timestamp# to give me usable data but it only seems to return null or 12:00 AM values. an example of the code i have been trying is: time(num#(mid(time1,1,4))). when i use the code without the time function in front i get results like this: 0538.
So i ended up using a code similar to the one you suggested in addition to the information you gave me about how QV operates with its time function. time#(time((num#(Left(TIME,4))/2400),'hhmmtt'),'HHMM')
Thanks for all of your help. I think this solves my problem. Matt