Display Date on the fly out of Timestamp

[stausen]

Hi,

I have created a new list with some joins to an extern db connection. Since two days I'm trying to display the timestamp linke "1466114460" as a normal date without modifying the field.
I tryed it in the specific field element with the sprintf function and with the individual calculation part. But I'm not able to get it in the list overview.

Is it possible? If yes could please somebody tell me how?

Thanks and best regards.

 

[cheesegrits]

Can you create another field on that table?

-- hugh

 

[stausen]

Hi thanks for answer,

it's possible but not a good solution because of update compatibility. Didn't know that this is such difficult because it's only a point of visibility. I thought maybe i can do it in the row_.php or at least whith javascript.

 

[stausen]

For anybody how's searching for a similar solution. Over the specific element options in fabrik I gave the unix timestamp element a specific class called "datum". In a separate js file I added the following:

$( ".datum" ).each(function( index, element ) {
var a = parseInt($(this).text());
$( this ).html(new Date(a).toUTCString());
});

Hope this helps...

 

[cheesegrits]

Thanks for following up with the solution.

-- hugh

 

[leblancphil]

Thanks, it works