date filter

[ManuelRodrigues]

Hi All,

I was wondering if someone can help me with a date filter that is dynamic rather than me having to input into the formula. I have a join tool input with a start and end date column and was wondering if i can somehow use those?

[GrowthNatives]

Hi @ManuelRodrigues, 

Yes, you can definitely make your date filter dynamic using the Start Date and End Date columns from your join input.

Here’s how to update your Filter tool’s custom expression:

[Posting Date] >= [Start Date]
AND
[Posting Date] <= [End Date]

Make sure:

1. All three fields (Posting Date, Start Date, End Date) are in Date format — use a DateTimeParse or DateTimeTrim if needed.
2. The fields are available in the same data stream before the Filter tool (usually after the Join).

This way, the filter will always adjust to whatever Start and End Dates are coming from your input — no need to hard-code!

⭐Hope this solution helps you make the most of Alteryx! If it did, click 'Mark as Solution' to help others find the right answers.

💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!

🚀Let’s keep building smarter, data-driven solutions together! 🚀

[binuacs]

@ManuelRodrigues if you are filtering the previous quarter records then the below condition should work