topic Re: Timestamp - 823 should not be 20:23 in App Development

Timestamp - 823 should not be 20:23

Nipija — Sun, 27 Jan 2019 11:43:21 GMT

I have a timestamp in my imported data. I tried to use timestamp format hh:mm in the data handle. We have 24h format and time stamps don’t work for me if data are 823, 934 since it return data as 20:23, 21:34. I want to have 8:23 and 9:34. Other time stamps as 1023 work fine since its 4 digits. Better to solve in expression? How to get correct time from 823 and 1023.

Re: Timestamp - 823 should not be 20:23

dplr-rn — Mon, 28 Jan 2019 03:21:55 GMT

Whats you code for transforming the time. did you try something like below
==Time(Time#(TIME_FIELD,if(len(TIME_FIELD)=4,'hhmm','hmm')) ,'hh:mm')

Re: Timestamp - 823 should not be 20:23

Nipija — Mon, 28 Jan 2019 08:30:06 GMT

I tried a similar expression.Will try this again.
I Solved this with a own table with a "translation" for all possible timestamps. 731 -> 7:31. I will try to do it the "right" way with an expression.

Timestamps seems to be integer in the SQL sp the time 00:01 will be 1. I will not need the timestamps during the night for this case, but my translation table will work if needed.

Re: Timestamp - 823 should not be 20:23

Nipija — Mon, 28 Jan 2019 08:36:53 GMT

Your expression works fine.