Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unix timestamp from a string to date

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).Screen Shot 2014-07-02 at 09.42.33.png

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use a preceding load like:

load

      cmd,

      palnie,

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

load

      cmd,

      subfield(funnel,'|') as palnie;

View solution in original post

4 Replies
tresesco
MVP
MVP

Try like:

Load

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

Not applicable
Author

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

Screen Shot 2014-07-02 at 09.54.02.png

If I use like this:

Screen Shot 2014-07-02 at 09.56.24.png

I get this error:

Screen Shot 2014-07-02 at 09.56.02.png

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

tresesco
MVP
MVP

Use a preceding load like:

load

      cmd,

      palnie,

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

load

      cmd,

      subfield(funnel,'|') as palnie;

Not applicable
Author

Wow...that works.

Thank you so much, forever in your debt.