Calendar view of birthdays

[Tim_Wilson]

I have a table with information about kids on a team I coach. I have a field for their birthdates and use that to calculate their age divisions. I’d like to use a calendar view to show upcoming birthdays, but the calendar view based on their birthdates doesn’t work, of course, because their birthdates aren’t in the current year. Is there a way to do this?

[Lance_Recker]

I would have to try this, but here’s an idea: what about extracting the month and day from the birthdate using a formula and then concatenating them back together with the current year to get their birthday?

[Lance_Recker]

I tried this in a base I have containing an employee hire date field. To create a column with their hire date anniversary day, I created a new field containing the formula below.

CONCATENATE(MID({Hire Date}, 1, 2), MID({Hire Date}, 3, 4), YEAR(TODAY()))

This formula basically takes select pieces from the hire date (the month + the day) and adds the current year based upon today and then joins them all together. Once you try this and everything looks ok, you’ll then have to convert the column from formula type to date type and create a calendar view based upon that date.

[Mics_Sky]

Another way:
You can try this and use the optional parameters if needed and make sure you are in US format ( didn’t try myself !).

DATETIME_PARSE ( “’”
& MONTH( {Hire Date} )
& “-”
& DAY( {Hire Date} )
&"-"
& YEAR(TODAY(), [ format ], [‘locale’] )

[Tim_Wilson]

Thanks for the replies. I tried the datetime_parse approach, but didn’t realize that you can coerce a formula into a date. I’ll play with this some more. Thanks again.

[Emma_Dicks]

I have the same issue

[Lance_Recker]

What do you need help with?

[Tim_Wilson]

The calendar views will only display Date fields. Unless it’s possible to take a formula field and force Airtable to treat it like a date, I haven’t found a way to make this work yet.

[Lance_Recker]

I’ve been able to do it repeatedly. Using the formula I provided above, I am able to produce the date I need. Then, after the formula has been applied, I can change the field type from formula to date type. Once done, it can then be used for a calendar view.

Here’s a quick GIF showing how I did it.

And here is the resulting calendar view.

[Tim_Wilson]

I tried it again, and your solution using the CONCATENATE function works. I was unable to get it to work with the DATETIME_PARSE approach. Thanks for the help, Lance.