Pipeline Builder relative date

Ask the Community
1

What’s the best way to use relative dates in pipeline builder? Have some filters in my pipeline that filter on data before a dynamic date.

Thanks!

2

Hey @ssachdev, are you trying to filter on the dynamic date value? You can use current date (under the expression sub tab) and subtract/add from that as needed.

For example, if you wanted to exclude future rows you can filter on the date being on or before the current date.

4

Ah perfect, thank you!