Filter for DataTicker

I have setup a dataset with follow columns

  • wochentag
  • Beschreibung
  • sonstiges

For column wochentag i use Datatype “string” als “Auswahlbox” (kommasepariert: mondy, … , sunday).

I cannot get the SQL filter to work - i’d like to to use a filter that checks what day of the week it is an display the events for the weekday.

I use follow Filter: DATE_FORMAT(NOW(), %W) = ‘wochentag’

Can you help me please to find the mistake?

Many thanks …

you can use formula DATE_FORMAT(CURDATE(), ‘%W’) . (Column format string )
For event note :
CASE WHEN DATE_FORMAT(CURDATE(), ‘%W’) = “Tuesday” THEN ‘wow’ ELSE ‘puff’ END

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.

The Xibo Community site uses cookies. What are cookies?