topic Re: TIME# in QlikView

TIME#

Mon, 14 Oct 2013 12:23:18 GMT

Hi All

our DB stores the EDIT_TIME as a string like this 74533 for 07:45:33

How do I convert this to hh:mm

I have tried; Time(Time#(YN_EDIT_TIME, 'hhmmss'),'hh:mm') but its does not seem to work.

MayilVahanan — Mon, 14 Oct 2013 12:27:06 GMT

Try like this

Time(Time#(YN_EDIT_TIME, 'hmmss'),'hh:mm:ss')

Mon, 14 Oct 2013 12:27:25 GMT

it seems to work to me

dvasseur — Mon, 14 Oct 2013 12:32:33 GMT

Hi, Try this:

Time(Time#(If(Len(YN_EDIT_TIME)=5, '0' & YN_EDIT_TIME, YN_EDIT_TIME), 'hhmmss')) AS YN_EDIT_TIME

But it won't work if 11435 is for 11:04:35

rustyfishbones — Mon, 14 Oct 2013 12:34:42 GMT

Like Mayil said

Mon, 14 Oct 2013 12:35:43 GMT

Thanks

Yeah, 11435 = 01:45:35 and 111435 = 11:14:35

Mon, 14 Oct 2013 12:35:44 GMT

try this

time(time#(fieldname,'hmmss'),'hh:mm')

or this

Date(Date#(fieldname,'hmmss'),'hh:mm')

ThornOfCrowns — Mon, 14 Oct 2013 12:36:53 GMT

OP requires hh:mm:ss to hh:mm, I think.

CELAMBARASAN — Mon, 14 Oct 2013 12:37:02 GMT

You should use

Time(Time#(YN_EDIT_TIME, 'hmmss'),'hh:mm:ss') //based on 74533

if your DB stores 07:04:05 as 745 then You should use hms instead of hmmss(its fine only if it stores it as 70405)

dvasseur — Mon, 14 Oct 2013 12:37:40 GMT

If minutes and seconds always have 2 digits, it will be fine !

Thu, 05 Mar 2015 17:47:06 GMT

I have a question

Please help me

How i can switch to between pages in the qlikview project?

I wait to your answer