topic Coverttolocaltime in QlikView

Coverttolocaltime

Fri, 27 Nov 2015 09:26:47 GMT

Hi All,

I am trying to convert the format 29/08/2015 03:05:37 to time only but the problem is that I need to add 4 hours to it so that it reflect GMT+04:00.

So my answer should be 07:05:37.

My current line i my loading script is as below:

Time(Frac([createdtime]), 'hh:mm:ss') as Time,

Kind Regards,

Hasvine

Anonymous — Fri, 27 Nov 2015 09:33:16 GMT

Something like :

Time(Frac([createdtime]) + (4/24) , 'hh:mm:ss') as Time,

MK_QSL — Fri, 27 Nov 2015 09:39:57 GMT

=Time(Frac(TimeStamp#('29/08/2015 03:05:37','DD/MM/YYYY hh:mm:ss')) + Time#('4','h'))

Anonymous — Fri, 27 Nov 2015 09:40:22 GMT

see this:

May be helpful to you!!

Fri, 27 Nov 2015 09:44:56 GMT

Thank you all.

KR,

Hasvine