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).
Date( Num(Right(palnie,10)) / 86400 + 25569) as Date
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.
Use a preceding load like:
Date(Num(right(palnie,10))/86400+25569) as Date;
subfield(funnel,'|') as palnie;
Thank you so much, forever in your debt.
Retrieving data ...