Filtering Dates without Year

1

I have a doc with full dates. I want to recognize the anniversary of this date, and have a table but want to filter for upcoming anniversaries. This means I want to filter for upcoming date/month but not year. Is that possible?

2

Hi Allison.

You can use the below formulas to isolate day and month. If you need then in the same column, just use concatenate.

image
image

Regards
Piet

2 Likes
3

You may also find it helpful to build another column, “next anniversary”, using the Date() formula to adjust the year as needed

1 Like
4

Hi Nick

yes, Absolutely. I had a birthday calendar at some stage, and once I have congratulated the person, I had a button that would add 12 months to the date when clicked.

P

5

hi @abpedro ,

below the function that sets automatically the next BD date, I use this kind of logic often in the context of contract management (next pay date, renewal etc). You can do this in various ways, below one approach:

thisRow.[BD USA].Substitute(thisRow.[BD USA].Year(), ToDay().Year())
  .WithName(TheNextBD,
    If(
      TheNextBD > Today(),
      TheNextBD,
      thisRow.[BD USA].Substitute(thisRow.[BD USA].Year(), ToDay().Year()+1)
    )
  )

image
image1680×670 89.1 KB

once you have this, you can extract the years in the filter on the year in the column Next BD as @Nick_HE suggested.

hope it helps, cheers, Christiaan

3 Likes
6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.