Unix timestamp from a string to date

[#1]

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]

Try like:

Load

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

[#3]

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 · Accepted solution]

Use a preceding load like:

load

      cmd,

      palnie,

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

load

      cmd,

      subfield(funnel,'|') as palnie;

[#5]

Wow...that works.

Thank you so much, forever in your debt.