Create Ticket My Tickets Post Discussion
Velkommen
Logg inn  Registrer deg
Hvordan kan vi bistå deg i dag?
  1. Diskusjoner
  2. Forums
  3. Logic & Functions
Besvart

Calculate a difference in dates by month

I
Ilana Chomsky
startet et emne almost 4 years siden

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.

  • S
    Sonny Crockett
    sagt almost 4 years siden

    Hi Ilana,


    Give this a shot for the validation on the date field:

    (ABS(DATEDIFF({{dateOriginal}},Now(), 'MM'))) DIV 12 < 5


    Sonny

Logg inn eller Registrér publiser en kommentar
Topics in this forum
View all (12)

Didn't find what you were looking for?

Start et nytt emne