Forum Discussion
Comparing Date Diff between Two Date fields but need to know if Met OnTime
- 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"
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"
- Anonymous5 years agoNot applicable
Thank you!