Power Platform Community Forum Thread Details

I'm building a Power App to display work anniversaries that occur this week.

I have a list with fields and data like this...

Name: Jon Doe

Hire Date: April 2, 1970

Location: St Louis

My app needs to show...

Jon Doe Apr 2

St Louis 53 Years

To get "Apr 2" I successfully used AddColumns to add "ShortHireDate" using... Text(DateValue(mm/dd/yyyy), "mmm dd")

I got the years successfully using AddColumns to add "Years" using... DateDiff(field_3, Today(), TimeUnit.Years)

Problem: I need to filter my list to show only items where the month/day matches a month/day combo for this week?

My idea is to use AddColumns to add a column called "Anniversary", which stores the month and day from "Hire Date" but with the current year.

Example:

Hire Date: 04/02/1970

Anniversary: 04/02/2023

Then I can filter the gallery view using...

Filter(
colAnniversaries,
Anniversary >= Today() - Weekday(Today()) + 1 && Anniversary <= Today() + (7 - Weekday(Today()))
)

How would I go about populating the "Anniversary" field using the month and day from "Hire Date" but the current year?

Categories:

Need to copy "Hire Date" to new column, only with the current year, as "Anniversary"