Birthday calendar

FME_Cavinder

Looking for a way to put team member's birthdays and anniversaries onto a calendar card for the team to see.

Thanks in advance

FME_Cavinder

Found a cheat way, just created a BM to put everything into the current year.

date((SUBSTRING(CURRENT_DATE(),1,4) * 10000) + (MONTH(`BDAT_DATE`) * 100) + DAY(`BDAT_DATE`) )

MarkSnodgrass

I would suggest using the calendar card. Then, if your data contains their actual birthday, to get their birthday into the current year, you could use this beast mode:

ADDDATE(`birthdate`, interval (YEAR(CURRENT_DATE())-YEAR(`birthdate`)) year)

Here's a link to the KB article for the calendar card.

https://domohelp.domo.com/hc/en-us/articles/360043427973-Calendar

Ashleigh

@FME_Cavinder I'm sure my method is a little outdated but for anniversary dates I have a table card that just shows employees and all their service dates. I then use this beastmode to color anything within 30 days.

case 

when DAYOFYEAR(`Latest Hire date`) - DAYOFYEAR(CURDATE()) < 0 then 'Past Date' 

when DAYOFYEAR(`Latest Hire date`) - DAYOFYEAR(CURDATE()) <= 30 then 'Within 30 days' 

when DAYOFYEAR(`Latest Hire date`) - DAYOFYEAR(CURDATE()) > 30 then 'More then 30 days' 

end

Then I use this BM to filter on Next Month and send a report to the managers so they know which of their employees have upcoming service days.

Case

When MONTH(`Latest Hire date`) = MOD(MONTH(CURDATE()),12) + 1 then 'Next Month' 

else 'Other'

End

FME_Cavinder

Found a cheat way, just created a BM to put everything into the current year.

date((SUBSTRING(CURRENT_DATE(),1,4) * 10000) + (MONTH(`BDAT_DATE`) * 100) + DAY(`BDAT_DATE`) )