Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Comparing Date Diff between Two Date fields but need to know if Met OnTime

Comparing Date Diff between Two Date fields to determine if my team is meeting expectations OnTime.      I have determined the duration between the dates but need to know: Is the Close Date Month...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You can have new columns like

     

    KPI Status = if([Close Date Month] >=[Expiration Date Month],"KPI Met (OnTime)", " KPI Met (not OnTIme)")

    Diff when not met = if([Close Date Month] >=[Expiration Date Month],blank() , datediff([Close Date Month],[Expiration Date Month],day))

     

    or  one combined  


    combined = if([Close Date Month] >=[Expiration Date Month],"KPI Met (OnTime)", " KPI Met (not OnTIme) ") & if([Close Date Month] >=[Expiration Date Month],blank() , datediff([Close Date Month],[Expiration Date Month],day)) & " months behind"