Dataset SQL filter format in v4 for meeting room schedule

[ProServ]

The date format between dtMeetingStart/dtMettingFinish and NOW() SQL function il not the same format.

In dtMeetingStart/dtMettingFinish columns you have “May-22-24 10:00 AM” = M-d-y h:i A
NOW() SQL function return 2024-05-22 10:00:00 = Y-m-d H:i:s

MySQL NOW() Function

.
So you must format your columns in the NOW() SQL function format, or create a formula column and use this one to filters.

How to change the date format in your DataSet

How date data is handled in Xibo Datasets. When using a Remote DataSet or CSV file with your Xibo Signage you may need to include date data. How date data is read and formatted varies greatly across different applications and spreadsheet applications. Xibo uses year/month/day order by default. To demonstrate how to format the date I have created a small CSV file containing date data in year/month/day hour:minute order. [image] When I import my CSV file into my DataSet, the date is still shown…

You can use this topic for an exemple:

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

And use PHP date/time format documentation:
https://www.php.net/manual/en/datetime.format.php