Skip to content

Instantly share code, notes, and snippets.

@ejangi

ejangi/Salesforce-Contact-Last-Interaction-Date-Formula.sql

Created September 24, 2018 23:08
Show Gist options
  • Save ejangi/d80ce71219ec7f7ee6f7f85e0e053b80 to your computer and use it in GitHub Desktop.
Save ejangi/d80ce71219ec7f7ee6f7f85e0e053b80 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Salesforce-Contact-Last-Interaction-Date-Formula.sql
IF(
AND(
ISBLANK(Last_Fundraiser_date__c),
ISBLANK(npo02__LastCloseDate__c),
ISBLANK(npo02__LastCloseDateHH__c),
ISBLANK(npo02__LastMembershipDate__c),
ISBLANK(npsp__Last_Soft_Credit_Date__c),
ISBLANK(GW_Volunteers__Last_Volunteer_Date__c)
),
NULL,
TODAY()-MIN(
TODAY()- BLANKVALUE(Last_Fundraiser_date__c,DATE(1900,1,1)),
TODAY()- BLANKVALUE(npo02__LastCloseDate__c,DATE(1900,1,1)),
TODAY()- BLANKVALUE(npo02__LastCloseDateHH__c,DATE(1900,1,1)),
TODAY()- BLANKVALUE(npo02__LastMembershipDate__c,DATE(1900,1,1)),
TODAY()- BLANKVALUE(npsp__Last_Soft_Credit_Date__c,DATE(1900,1,1)),
TODAY()- BLANKVALUE(GW_Volunteers__Last_Volunteer_Date__c,DATE(1900,1,1))
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment