List of program registrants in the next 5 days

Josh Cross
Josh Cross
Third Anniversary Blackbaud Champion
in Blackbaud Altru® General Discussions

I need to create a query that lists anyone that registered for a program that's coming up in the next 5 days. I'd like it to be dynamic so no matter when you run it, it's always looking 5 days ahead. Is this possible?

Tagged:

Comments

  • Margaret Matteson
    Margaret Matteson
    Fourth Anniversary Kudos 2 Name Dropper Participant

    The best Altru can do for dynamic dates are the following: Tomorrow, This Week, Next Week. So, if you can deal with having a further out date range, you could do “This week or Next Week”.

  • Beth Trainer
    Beth Trainer
    Sixth Anniversary Kudos 1 Name Dropper Participant

    Hi Josh, One thing I like to do in instances like this is utilize an odata connection in excel to your query. This way, you can easily have your dynamic content on a larger date range, ie. this month, quarter, and then utilize excel functions such as timeline or slicer to dial into the date range you are looking for without always having to update your query. If you aren't familiar with odata, happy to connect and walk you through some of my examples.

Categories