Forum Discussion
NicholasBowman
8 years agoNew Member
Date Formula
Currently trying to convert a person's birth date to the same month and day in the current year. I have used the date formula as such: Birth Date This Year = DATE(YEAR(today()),MONTH(contacts[Birth D...
NicholasBowman
8 years agoNew Member
Thanks, i did try this but ended up with the same error response. Tried to test it another way by using an if function to return a different result if the DAY(date) = 29, but that also resulted in the same error
v-jiascu-msft
8 years agoMicrosoft Employee