ContributionsMost RecentMost LikesSolutionsRe: Report on Recurring Dates Annually?Thanks everyone for the comments and help. Part of the struggle is that we want to be able to show the Month/Date and the current year... I was able to accomplish this in a horrifically inefficient way, but here goes my solution: Created a "DOB" [Date Field] (Technically, Optional) Created a "Month of DOB" [Text Field] Created a "Date of DOB" [Text Field] Created a "Today" [Date/Time Formula Field -Now()] Created a "Year" [Text Formula Field -Year(ToDate([Today]))] Created a "Current Year DOB" [Text Formula Field -[Month of DOB]&"-"&[Date of DOB]&"-"&[Year]] Created a "Current Year DOB01" [Date Formula Field -ToDate([Current Year DOB])] For Next Year: Create a "Next Year" [Numeric Formula Field -ToNumber([Year])+1] Create a "Next Year DOB" [Text Formula Field -[Month of DOB]&"-"&[Date of DOB]&"-"&[Next Year]] Create a "Next Year DOB01" [Date Formula Field -ToDate([Next Year DOB])] I'm going to replicate this for the anniversary need. I appreciate everyone's help! Re: Report on Recurring Dates Annually?Rob, thanks for the comment. In my case, I am not sure that this would not work, as we are trying to capture the date and month of the DOB and report on it year over year. My initial thought was to have some sort of concatenate date formula by converting the date and month to numeric values and marry those values with the current year, creating a copy of the DOB in the current year and next year. Also, I have the quarters setup in QB already to follow a calendar schedule, so as long as I can convert the date to the current year, I should be in good shape.Report on Recurring Dates Annually?I am trying to create a report that shows "Birthdays within the next 7 days" and "Anniversaries This Quarter" and I am hitting a brick wall due to the "year" part of the DOB/Start Date fields. Any suggestions for how I could manipulate a DOB or anniversary date field into being able to report "Birthdays in the Current Week", "Birthdays Next Week", and "Anniversaries in the Current Quarter"?