Datasets: Unix Timestamp

[ProServ]

@Arnold_Naber

I now get 8-apri. i would rather have 8 April

Try with:

$dateFormat((FROM_UNIXTIME(UTdate),d F)

https://www.php.net/manual/en/datetime.format.php

@Arnold_Naber

I only need it to sort the results to the current day so i need to figure that out next.

May be a solution to your needs:

Filter today's events in dataset

Hi, Finally got the advanced filter to work for showing only today’s events from a dataset. I used the following query where Starts is the event starting date. DATE_FORMAT(NOW(), ‘%Y-%m-%d 00:00:01’) < Starts AND Starts < DATE_FORMAT(NOW(), ‘%Y-%m-%d 23:59:59’) May help someone. CMS v1.8.7

or:

Dataset API - Filter row on Dates

Would someone be able to post an example of filtering a Dataset’s Data based on a date value? It’s easy to filter on a single column that is a String Value. The example below works: /api/dataset/data/1?Location=Room 1 However the same format above does not work for a date field. I want to query the API for dataset results where the date column that falls within a specific date range.