Ticker Dataset Advanced SQL Filter by Date and Time Error

Hi,

Can someone assist to advice how to proceed and whats wrong with the Ticker Dataset SQL filter below , somehow it doesnt seem to work.

Environment
XIBO 1.8.12
Ubuntu 18.14
Local Installation (not using Docker)

Created a Dataset having :
Col1 - Type String - Name Time1 Example 08:30 , 10:20 , 11:15
Col2 - Type String - Name Time2 Example 10:30 , 11:00, 12:15
Col3 - Type Date - Name MyDate Example 2019-10-07, 2019-10-06, 2019-10-08

My filter for the Ticker Datase to work based on :

DAY(MyDate) = DAY(CURDATE()) AND MONTH(MyDate) = MONTH(CURDATE()) AND YEAR(MyDate) = YEAR(CURDATE()) AND TIME_FORMAT(Time1, “%H:%i:%s”) > ADDTIME(CURTIME(),“0:5:0”) AND TIME_FORMAT(Time2,"%H:%i:%s’) < CURTIME()

The Xibo Community site uses cookies. What are cookies?