SOLVED - Data Set Filters

Get Help
1

I’m struggling to wrap my head around how best to accomplish this. I have a data set of upcoming events, for the longest time I’d just go in regularly and flush out the old items but it looks unprofessional for us to have several day old events, especially when the container is overflowing and one can’t see the valid ones.

All I’m looking to do is filter a data set so that only items for this month and maybe the following month are displayed, anything older or new than that is ignored.

The first problem I’ll probably have is the dates. Its just a free-form field and dates are usually expressed as 01/31 as in month/day. If I have to change the ways these values are stored that’s fine, but I might ask, is there a way to format the values they store so when they go to the screen they’re in a eye friendly format?

2

What I did was add another field to my csv file for the date in the format that Xibo likes yyyy-mm-dd named sHidden that was copied from the regular date we have mm/dd/yyyy and cell formated in excel. Then I added a sql filter query to pull only the dates for the next seven days from the current date using the sHidden field.

NOW() < sHidden and (NOW() + INTERVAL 7 DAY > sHidden)

and just add the apperance of the date, time and title of the event. This way in my dataset I add three months worth of info and the query will pull and display all events from tomorrow to seven days from tomorrow.

3

That worked beautifully, thank you very much for the guidance.

1 Like