Dataset Birthday

Get Help
1

Hi Peter.

How are you?

I need create a layou of birthday. I saw another post where you explain how make the SQL query for this.

My question is. When my dataset don’t have birthday today i want show a message like “Today we have no Birthday” .

How can i do this?

Thanks.

1 Like
2

This is very interesting, also like to know how to do.

3

Hi Peter,

can you link the original post please?

4

Here you go

As for the question in this topic, I’ll think about it, I am not sure yet if there is reliable way to do this.
I’ll reply later today.

5

Ok, it took some time, it’s not as easy as it may seem.

I am not saying it’s the Best solution or only solution but hopefully it will be good enough and someone will use it :smile:

We might implement a way better way to deal with it, in similar fashion like we have ‘no tweets’ message in twitter module, so for now we don’t have anything like this for ticker/dataset and again my solution is not perfect but it should do the work.

So example dataset:

Pasted image1013×293 9.83 KB

Is it necessary to have separate column ‘NotBirthday’? No it’s not, but it clearer to see (at least I think so)

now for the filter:

(DAY(Birthday) = DAY(CURDATE()) AND MONTH(Birthday) = MONTH(CURDATE()) AND YEAR(Birthday) <= YEAR(CURDATE())) OR (DAY(NotBirthday) <> DAY(CURDATE()) AND MONTH(NotBirthday) <> MONTH(CURDATE()) AND YEAR(NotBirthday) > YEAR(CURDATE()))

So the message in ‘NotBirthday’ row will always be displayed, you absolutely can change it, here it’s just an example. (it’s not necessary to have YEAR there, but this way you can also enter actual birthday dates ie 1989-03-25 for example)

So for today 19.10.2015 assuming in appearance tab you have only ‘Name’ column.
it will display
guy a
guy b
No more Birthdays today!

for tomorrow, where none has birthday it will just display:
No more Birthdays today!

So you see it’s not perfect, but I believe it’s better than empty region. I had different ideas too, but it was too easy to prove that sooner or later it won’t work properly so the solution above works best and it’s not necessary to alter the data because of the filter.

6

Hi Peter.

Ok. I agree with you. It’s easier prepare the base.

Thank you.

7

Hi Peter,

The system does not work when I enter the data in 01.03.2019 format in Dataset Birthday field.But when I write in 2019-03-01 format the system is running.how do i fix this

Best Regards

8

Well, you can’t use dd.mm.yy