I need to be able to enter a date without a year

Topic Labels: Dates & Timezones
2423 6
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I’m working on an app to keep records for a children’s club. We try to get their birthdays, but sometimes they don’t know the year they were born. Is there a way to enter only the month and day?

Ultimately I want to use the date to calculate the age, but I can have a check box to test if the date isn’t complete. Alternately, maybe I can use the age if we know it to calculate the year.

I would like ideas for the best way to handle this. Thank you.

6 Replies 6

You could create 3 different fields (Month, Day, and Year), and just leave the Year field blank when you don’t know what it is.

6 - Interface Innovator
6 - Interface Innovator

Short of any other ideas, I may enter the month and day in fields, then use them along with the age to calculate the year and enter all of them in the date field.

7 - App Architect
7 - App Architect

I have this same question but for two different scenarios.

I actually do something similar to this kids case study but in my case, with actors, to track their ages for roles 😉 but I also need it for gardening (I don't want to have to keep putting in the same ballpark seasonal dates of when to sow, plant indoors, transplant outdoors, etc.) and/or say film festivals and awards shows (annual events that are ballpark right around the same time - and I can adjust annually as they shift a weekend or two). 

I can certainly split into three columns (but then I lose the ability to do the calendar subscription - which is very handy) or add a column and a formula to add a year but... just thought I'd see if there were any easier other ways or brilliant ideas?

6 - Interface Innovator
6 - Interface Innovator

Just wanted to chime in and mention a desire for the same thing, particularly with a focus on the ability to have it show on the calendar each year. We track birthdays for employees but don't want the year visible, just the month/date.

Alternatively, is there perhaps a formula that would let us have a full date field and then only pull the month/day into a separate field? We could hide the full date and only have visibility on the month/day and that would meet the need in our situation.

@Mouser-IB-Admin - Having separate columns for Month, Day and Year SHOULD solve this for you.

You could then use a formula to concatenate just the Month and Day for your calendar subscription. 😉  

That's the suggestion I keep seeing in other similar posts too, so it may  unfortunately be the only way to do it.. Thanks!