Query by days since last gift date?

Sherry Aldrich · September 2019

Is there a way to run a query in RE or NXT based on the number of days since a constituents last gift date?

For example: I would like to see everyone who has a last gift date greater than or equal to 365 days or more?

Thanks!

Sherry

Mark Guncheon 2 · September 2019

I don't know that this can be done in RE or NXT.

I've done this in excel. Export a group that includes last gift date and then subtract a "today's date" column from that column to get a number that equals days since last gift. I've done this mainly with actions but it works with any dates.

Jason Black · September 2019

Sherry,

You can do this, but in Query it would require that you enter a new reference date each time you run it - it won't automatically look back 365 days for you. You would use Last Gift Date with the <ask> operator. Each time you run the query (or run an Export or Report referencing that query) it'll ask you for a date. You can then select the "less than" operator, and pick the date one year ago (e.g. 09/16/2018, if running it today).

The only way I know to get around the fact that RE Query won't automatically look back over a specific period is to create a custom report and instruct Crystal Reports to do it.

Christine Cooke 2 · September 2019

why not use the LYBUNT ? you can have it produce a query if you need it of NXT or for an export with detailed info that is not included on the LYBUNT report.

Dennis Ladnier · September 2019

you could recreate a VBA field which calc's the # of days since last gift date - this would work.

Query by days since last gift date?

Comments

Categories