COREY'S SUPPORT RESOURCE
SQL for Filters & Calculated Fields
Date Field SQL
Last 12 Months (or X number of months)
Gift Date: DPGIFT.GIFT_DATE >= DATEADD(MM,-12,GETDATE()) Last Gift Date: DP.LAST_CONTRIB_DATE >= DATEADD(MM,-12,GETDATE()) First Gift Date: DP.INITIAL_GIFT_DATE >= DATEADD(MM,-12,GETDATE()) Contact/Entry Date: DPCONTACT.CONTACT_DATE >= DATEADD(MM,-12,GETDATE()) Other Date: DPOTHER.OTHER_DATE >= DATEADD(MM,-12,GETDATE())
Last 365 Days (or X number of days)
Gift Date: DPGIFT.GIFT_DATE >= DATEADD(DD,-365,GETDATE()) Last Gift Date: DP.LAST_CONTRIB_DATE >= DATEADD(DD,-365,GETDATE()) First Gift Date: DP.INITIAL_GIFT_DATE >= DATEADD(DD,-365,GETDATE()) Contact/Entry Date: DPCONTACT.CONTACT_DATE >= DATEADD(DD,-365,GETDATE()) Other Date: DPOTHER.OTHER_DATE >= DATEADD(DD,-365,GETDATE())
Last Calendar Year (or LY#_CYTD)
Gift Date: datepart(yyyy,DPGIFT.GIFT_DATE) = (datepart(yyyy,getdate())-1) Last Gift Date: datepart(yyyy,DP.LAST_CONTRIB_DATE) = (datepart(yyyy,getdate())-1)
Last Calendar Year to Date (or LY#_CYTD)
Gift Date: DATEPART(YYYY,DPGIFT.GIFT_DATE) = (DATEPART(YYYY,GETDATE())-1) AND DATEPART(DY,DPGIFT.GIFT_DATE) <= DATEPART(DY,GETDATE()) Last Gift Date: DATEPART(YYYY,DP.LAST_CONTRIB_DATE) = (DATEPART(YYYY,GETDATE())-1) AND DATEPART(DY,DP.LAST_CONTRIB_DATE) <= DATEPART(DY,GETDATE()) First Gift Date: DATEPART(YYYY,DP.INITIAL_GIFT_DATE) = (DATEPART(YYYY,GETDATE())-1) AND DATEPART(DY,DP.INITIAL_GIFT_DATE)
Last Calendar Year (or LY#_CYTD)
Gift Date: datepart(yyyy,DPGIFT.GIFT_DATE) = (datepart(yyyy,getdate())-1) Last Gift Date: datepart(yyyy,DP.LAST_CONTRIB_DATE) = (datepart(yyyy,getdate())-1)
Gift Date: DPGIFT.GIFT_DATE >= DATEADD(MM,-12,GETDATE()) Last Gift Date: DP.LAST_CONTRIB_DATE >= DATEADD(MM,-12,GETDATE()) First Gift Date: DP.INITIAL_GIFT_DATE >= DATEADD(MM,-12,GETDATE()) Contact/Entry Date: DPCONTACT.CONTACT_DATE >= DATEADD(MM,-12,GETDATE()) Other Date: DPOTHER.OTHER_DATE >= DATEADD(MM,-12,GETDATE())
2 / Item Title
Collapsible text is great for longer section titles and descriptions. It gives people access to all the info they need, while keeping your layout clean. Link your text to anything, or set your text box to expand on click. Write your text here...
3 / Item Title
Collapsible text is great for longer section titles and descriptions. It gives people access to all the info they need, while keeping your layout clean. Link your text to anything, or set your text box to expand on click. Write your text here...