Welcome to Luminate Ideas!

Please submit all product enhancement ideas below. We welcome your feedback; your ideas will be reviewed by the Product Manager that oversees the development of that part of the product on an ongoing basis and updated with its current status monthly based on our product planning process. Ideas you submit could help us shape features currently in development or grow our repository of requirements for our next big enhancement. Thank you for taking the time to share your thoughts and expertise with us.

If you believe you are experiencing a defect please contact Support.

Query a field where a date field is today - for instance their Birthday or Anniversary

Be able to build a query in order to populate a group based on the month and day in a field but not the year. If I try to run a query where first_gift_date or birth_date or anniversary_date is equal to today it fails because 4/1/2015 will never be equal to a date in the past. Give me an option to say where 4/1/2015 is an anniversary of first_gift_date or birth_date or anniversary_date. Right now the solution is to say where the date equals 12 months from today or 24 months from today or 36 months from today etc for 70, 80, 90 years.

  • Ken Cantu
  • May 11 2015
  • Shipped
Area of the Product Reporting
Org/Company Name University of Washington
  • Attach files
  • Maria Shanley commented
    6 Dec, 2017 08:39pm

    thank you! thank you! going to set it up now.

  • Ken Cantu commented
    6 Dec, 2017 08:36pm

    Hmm, sorry about that but yes, I promise it does : ) 

  • Maria Shanley commented
    6 Dec, 2017 08:31pm

    oh nice! awesome. I just talked to support and they told me that it did not do this. That's why I was confused.

    thank you!

  • Ken Cantu commented
    6 Dec, 2017 08:29pm

    There is a button in LO beta List that you create where you can "Push to Luminate Online". This creates a group in LO based on the query you ran in LO Beta. You then target this group like normal with your email campaign and set to rebuild the group on email send and it will update the group like normal. 

  • Maria Shanley commented
    6 Dec, 2017 08:22pm

    I"m confused. But it creates a group in BETA. Not a query that you can use for an email campaign. right? did i miss something?

  • Ken Cantu commented
    13 Oct, 2017 06:41pm

    Good news, this is now available in LO Beta Lists!

Privacy Policy | Safe Harbor Notice | Terms of Use | Acceptable Use Policy | © 2019 Blackbaud, Inc. All Rights Reserved