Query to retrieve guests who registered in the last few days

Paul Robertson
Paul Robertson
Name Dropper First Anniversary Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions

Hi All,

I'm trying to create a dashboard in RE database view that shows invitees who have registered in the last few days. For the query the date filter I want is something like Today() - 3 days.

Is this possible?

Thanks,

Paul

Tagged:

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Paul Robertson
    Accuracy depends on your data entry practice.

    If your data entry process requies the entry of the registration date, then you can query on that field.

    otherwise, you can “kind of” get this by using the “date added” field on the participant record.

  • Alan French
    Alan French
    Tenth Anniversary Kudos 5 Name Dropper Participant

    @Paul Robertson do you mean that you want it to be a rolling date period that you don't have to update each time? I'm not sure RE can do that in a query

  • Paul Robertson
    Paul Robertson
    Name Dropper First Anniversary Facilitator 1

    @Alan French
    Hi Alan. Yes I was hoping to have a rolling date period. I couldn't see a way to do it so thanks for confirming.

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Paul Robertson
    I think in query, you can do today and yesterday.

    So as long as the date field is “true” date field, instead of fuzzy date (i don't remember if registration date is fuzzy or true), you can do:

    date is today
    or
    date is yesterday

    to capture 2 days worth.. but not more than that

Categories