Help me please (partial dates) Hello, I would really appreciate some help here. I have a big list of client birthdays, the majority of them are partial dates (DD/MM), but some are complete dates (DD/MM/YYYY). Now, I have 3 fields:
Date of birth
This is a single line text field because I can’t enter partial dates in a date field
Age
This is a formula field I use to get their age when I do have their full date of birth
IF({Date of birth}, DATETIME_DIFF(TODAY(), {Date of birth}, ‘years’))
Birthday
This is a formula field I’m using to strip away the year of complete dates and make both, partial and complete dates, recurring dates that I can see in the calendar view
IF({Date of birth}, DATETIME_PARSE(DATETIME_FORMAT({Date of birth},‘MM/DD’)&"/"&YEAR(NOW())))
The problems I’m having are the following:
We use the European date format (DD/MM/YYYY) here, but when I enter a partial date in the date of birth field (single line text field), say, 1/6 (June 1st), the birthday field (date field, European date for
