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
    December 06, 2017 20:39

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

  • Ken Cantu commented
    December 06, 2017 20:36

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

  • Maria Shanley commented
    December 06, 2017 20:31

    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
    December 06, 2017 20:29

    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
    December 06, 2017 20:22

    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
    October 13, 2017 18:41

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