topic Re: Unix timestamp from a string to date in QlikView

Unix timestamp from a string to date

Wed, 02 Jul 2014 06:45:08 GMT

Hello,

I have problems converting a unix timestamp to date. Is there a way to convert unix timestamp to date?

Please check the attched file. I get the unix timestamp with right(palnie, 10).

tresB — Wed, 02 Jul 2014 06:52:36 GMT

Try like:

Load

Date( Num(Right(palnie,10)) / 86400 + 25569) as Date

Wed, 02 Jul 2014 06:57:42 GMT

The problem is a cannot use 'palnie' in scripting, i guess because it is a variable from string manipulation.

If I use like this:

I get this error:

I've been working on this problem for almost 4 hours.

tresB — Wed, 02 Jul 2014 07:04:23 GMT

Use a preceding load like:

load

cmd,

palnie,

Date(Num(right(palnie,10))/86400+25569) as Date;

load

cmd,

subfield(funnel,'|') as palnie;

Wed, 02 Jul 2014 07:14:55 GMT

Wow...that works.

Thank you so much, forever in your debt.