I have some issue with creating layout with ticker connected to dataset. My dataset looks like below image. On layout I’d like to filter records based on dates and rook name. So I use SQL filter like this:
Sala LIKE “Roza” AND NOW() > Start AND NOW() < Koniec
Unfortunetly it is not working. When I reduce filter to:
NOW() > Start AND NOW() < Koniec
I works fine.What can be the reason of such behavior?