Using DataSets to display Birthday


#1

I want to use the Datasets to display Birthdays of people.
How can I change the filter to display the birtdays of that day NOW()?

Continuing the discussion from Using DataSets to Display Meeting Room Bookings:


Dataset Birthday
#2

Hi,

NOW() > Start AND NOW() < End

Assuming Start/End - are the day of someone’s birthday it should work. ie:

Start 2015-09-01 00:00:00
End 2015-09-01 23:59:59

Then with this filter it will show only record(s) of people that have birthday on that specific day.

As for dataSet you would need just dates and [Name] I guess, then in ticker add this filter and in appearance the [Name] tag.


Using Dynamic Data Source As Text
#3

Peter,

I use only one date and no time.

Date 2015-09-02`

Is there a filter option for NOW() to check only on the date.

Then I will have a filter like

NOW(??) = Date

#4

Yeah I guess you can do something like that
Your Column with ‘Date’ in my example is named ‘Birthday’ it’s a column in date format and 2015-09-03 dates in rows so something like you already have.
Then in filter you can put something like this:

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

Where ‘Birthday’ is a column name with dates so you might want to change that if your column has different name

It should work just fine


Using Dynamic Data Source As Text
Dataset column formula
Displaying correct Anniversary dates on specific day
Missing "Dataset view" module
Dataset with date includes 00:00:00 time, which prevents a CURDATE() lookup
#5

Peter,

Great it works!! :grinning:

Thanxs


#6

Cool :smile:

In this case, I’ll close this topic.


closed #7