Answered
Calculate a difference in dates by month
Does anyone have an idea for this? I want to calculate if a license has expired. If it's been more than 5 years since the license was issued, I want to flag it. The DATEDIFF function seems to be the best choice but I can't figure it out. And I want it to only flag if it's been more than five years to the month, not the whole year.
Hi Ilana,
Give this a shot for the validation on the date field:
(ABS(DATEDIFF({{dateOriginal}},Now(), 'MM'))) DIV 12 < 5
Sonny