I am setting up a personnel directory and wanting to create a Birthday Calendar off of a Calendar Report keying on the date field that lists everyone's birthday. How can I get it to read only Month and Day so it shows on the calendar.
------------------------------
Sam Ulmer
------------------------------
Question
Trying to create Birthday Calendar
This topic has been closed for replies.
+24np,
Try this
var date BirthdayThisYear = Date(Year(Today()), month([DOB]), Day([DOB]));
IF($BirthdayThisYear >= Today(), $BirthdayThisYear, AdjustYear $BirthdayThisYear, 1)
What that does is to calculate the birthday using the current calendar year. But then if that date has already passed then to advance the birthday to the next year.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Try this
var date BirthdayThisYear = Date(Year(Today()), month([DOB]), Day([DOB]));
IF($BirthdayThisYear >= Today(), $BirthdayThisYear, AdjustYear $BirthdayThisYear, 1)
What that does is to calculate the birthday using the current calendar year. But then if that date has already passed then to advance the birthday to the next year.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.