Datasets: Unix Timestamp

[ProServ]

Hi @Arnold_Naber

Here we can see that the columns can be given a formula:

Dataset DateTime - can i show only time/date

Hi, You could create a formula column and set the formula to $dateFormat(colWithDateIn,d-m-Y) where the colWithDateIn is the name of the column that contains the full date. d-m-Y can be any PHP date format (https://xibo.org.uk/docs/setup/date-format-php) I hope that helps Thanks, Dan

I had done something like this with SQL queries but I never converted a timestamp.

Please, let us know if you find the right formula.