Is a Variable Gift Date filter possible?

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?

Glen Hutson

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.

Matt Thacker

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.

Matt Thacker

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

Reuben Schmitz

Matt, thanks for the quick response.

Reuben Schmitz

Glen, thanks for the quick response.