Is a Variable Gift Date filter possible?

Reuben Schmitz
Reuben Schmitz
Fourth Anniversary Kudos 2 Name Dropper Participant
in SKY Developer General Discussions

I am creating a gift list and want to use the “Added on or after” Advanced filter field (which isn't avaialble in an NXT list). Is there an expression that can include only the past 7 days of gifts - with no specific date referenced? (to avoid having to manually update the date range weekly). If so, could you share it?

Tagged:

Comments

  • Glen Hutson
    Glen Hutson Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    Reuben Schmitz:

    I am creating a gift list and want to use the “Added on or after” Advanced filter field (which isn't avaialble in an NXT list). Is there an expression that can include only the past 7 days of gifts - with no specific date referenced? (to avoid having to manually update the date range weekly). If so, could you share it?

    There is both a “get past time” and “subtract from time” actions available under “Date Time”. You can use that to get 7 days ago and put that in the list gifts filter.

    c43e1e7ec2b44192887bfb86c4a548b9-huge-im
  • Matt Thacker
    Matt Thacker
    Fourth Anniversary Kudos 3 Name Dropper Participant

    Hey @Reuben Schmitz, here's how I'd do it. Initial a string variable with the expression utcNOW(). Initialize a second string variable with the expression addDays(nameOfFirstVariable, -7). This will take your first variable and take it back 7 days. Then pass that second variable into the List Gifts connector.

    cc5d76ca67c59c9c73deb7ddc8aef1a2-huge-im

    3048538cb73646b12a6b8cc27497cad7-huge-im
  • Matt Thacker
    Matt Thacker
    Fourth Anniversary Kudos 3 Name Dropper Participant

    This one is good to know, Glen! I had no idea that was a function. I just always manually create them.

  • Reuben Schmitz
    Reuben Schmitz
    Fourth Anniversary Kudos 2 Name Dropper Participant

    Matt, thanks for the quick response.

  • Reuben Schmitz
    Reuben Schmitz
    Fourth Anniversary Kudos 2 Name Dropper Participant

    Glen, thanks for the quick response.

Categories