Xibo

Date Filter for Dataset

Asked by Jeremy Rea

Hello,
I am trying to set up a way to display birthdays from a dataset. I have 3 columns; Name, Month of Birth, and Day of Birth.

I would like to filter by month and also be able to filter by day. Is there a variable I can use for the Day and the Month within the dataset filter?

Question information

Language:
English Edit question
Status:
Answered
For:
Xibo Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Dan Garner (dangarner) said : 		#1

1.5.1 supports "formula" data set columns, which can be any MySQL style syntax. You could use that to convert your month/day into a full date/time, which will make filtering easier (you can then just filter on a date comparison).

Revision history for this message
Barry Wood (barry-x8) said : 		#2

Can that 'date comparison' use something like 'TODAY' or 'NOW' so it can automatically pick up just the current day's events? That would avoid having to change values every time you wanted to display a set of records.

Revision history for this message
Jeremy Rea (l-mail-f) said : 		#3

Here is what I used as the filter. Seems to work perfectly. Birthday is the column with birthdays in DATE format.

DAY(Birthday) = DAY(CURDATE()) AND MONTH(Birthday) = MONTH(CURDATE())

Can you help with this problem?

Provide an answer of your own, or ask Jeremy Rea for more information if necessary.

To post a message you must log in.