Filter a date field based on day and month only | Community
Skip to main content
A
alisonf34704358
Level 2
October 12, 2023
Question

Filter a date field based on day and month only

  • October 12, 2023
  • 2 replies
  • 1877 views

I have a custom Birthday date field on my users' records. I want to make a report that shows whose birthdays are coming up in the next few weeks. The problem is that I want to be able to see which dates are coming up regardless of the year entered in the Birthday field (e.g. if someone's birthday is listed as 11/1/1980, I still want them to show as an upcoming birthday even though the date has technically passed). Is there a way to filter like this using text mode, or do I have to manually fake everyone's birth year each year?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

C
cverges
Level 5
October 12, 2023

One idea would be to create a calculated field that is just month/day.  If you use MM-YY (with zero padding) as a format, then it would always be sorted in proper numerical order.

A
alisonf34704358Author
Level 2
October 12, 2023

After a quick search I think I understand how to convert the Birthday field to a field like that, but how would I then compare it to today's date to see if it's within,say, 14 days?

C
cverges
Level 5
October 12, 2023

Great question.  No clue.  🙂

You could maybe do a Fusion process to calculate all the records that are coming up (because Fusion can calculate the date ranges involved) and then tag the records to flag them.  You'd also need to untag the records once they drop off.  It's a fairly straightforward set of scenarios, but you'd have to manage the scale of such a thing.

skyehansen
Community Advisor
skyehansenCommunity Advisor
October 12, 2023

I'm wondering if faking it is good enough. Can you put a year on the company object that everyone is in (hopefully you only have the one company) and then create a calculated field that is formatted as a date, and looks at the month and day of the birthday field, adding it to the year of the company field, and then just update the year and recalculate the calculated field once a year? This way you get to keep it as a date.

 

As an aside, I wouldn't feel great if my company was storing my actual date of birth on my Workfront user record. This is considered PII (personally identifiable information).

    A
    alisonf34704358Author
    Level 2
    October 13, 2023

    To your last point, I don't actually have the years of birth stored, just month and day. I have the years set as 2023 right now. Didn't feel like explaining that in my original post. But I'm thinking now I'm just going to manually change the year like you said. It's only ~40 people.

    NicholeVargas
    Adobe Employee
    NicholeVargasAdobe Employee
    Adobe Employee
    October 16, 2023

    If you have all the birthday years set as 2023 right now, you could run a user report and add the filter for User Birthday > Between > $$TODAY and $$TODAY+3w for example, and that will pull in all the birthdays in the next 3 weeks. You can change the date range to 1 month or 2 weeks, it would just be a slight variation in your date based wildcard. 

    Terms & ConditionsAccessibility statement

    Loading footer...