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

Login or Signup to post a comment