Rolling date-range in query filtering

When filtering on dates in query, the drop-down menu gives us a number of date-range options e.g. last week, this month, next quarter - what however we don’t seem able to do is add a ‘rolling’ date-range into a dynamic query e.g. in the last 3 months (90 days), in the 12 months (365 days)? There are quite a few situations where this type of rolling date parameter is needed, rather than a fixed period. It would be really helpful for Oxford's work if this could be made available via the SDK.
  • Guest
  • Jun 29 2015
  • Shipped
  • Attach files
  • Phil Higgs commented
    8 Oct, 2018 02:05am

    Hi all.

    David Bourne at the Winderness Society in Tasmania has shared a rolling date query view directly off a Constituent Record.

    Please contact him at david.bourne@wilderness.org.au

     

  • Guest commented
    4 Apr, 2018 07:38pm

    Please make the rolling dates available in the standard query tool for OLTP tables similar to for BBDW.

  • Lucy Jones commented
    16 Mar, 2017 01:32am

    Please make rolling dates available in the standard query tool. It's essential to many of our reporting needs and I don't think we should have to buy Data Warehouse for such a fundamentally useful feature.

  • Guest commented
    11 Aug, 2016 06:03am

    Hi Trit,

    Thanks for that clarification.  The answer before implied that it was generally available. We don't have the data warehouse so this is not useful to us.  It's such a fundamentally useful feature that I'm really hoping BB will add it to normal query soon.  See https://bbcrm.ideas.aha.io/ideas/CRM-I-2215.

    Regards,

    David.

  • Trit Mulligan commented
    10 Aug, 2016 02:49pm

    Hi David,

    The rolling dates feature is only available for queries built off of the Blackbaud Data Warehouse.  If you have the data warehouse deployed, within query, look for Constituent (from the Blackbaud Data Warehouse) and Revenue (from the Blackbaud Data Warehouse) query views.

    Thanks,

    Trit

  • Guest commented
    5 Aug, 2016 06:45am

    Hi Blackbaud, when you say that this is Shipped in 4.0, is that for the normal query engine (where we certainly can't find it) or the SDK (which we don't have).  Regards, David.

  • +144