Query to retrieve guests who registered in the last few days

Paul Robertson

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

Alex Wong

@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

@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

@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

@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