Forum Discussion
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...
Hi NicholasBowman,
The formula you are using should be correct, is the format of the Birth Date correct? Is it configured in your model as a date?
Regards,
MFelix
Hi! Thanks for your response. The formatting is correct - if i simply use the DAY function then it correctly extracts the day, but when i insert that in to the overall date function if get the error that 'an argument of function 'date' has the wrong data type or the result is too large or too small'. I am using the same column to determine the birthday month and day, so am struggling to understand why within the date formula there is suddenly an error (it works perfectly in the month position of the formula)
