Filter based on output value

[akasubi]

One part of my workflow calculates a "max date" based on some conditions and outputs this value. I would then like to apply a filter to the other part of the workflow so that date is less than or equal to this max date. What is the best way to do this?

date <= max(date)

Note: all done via in-db

Thanks!

[MarqueeCrew · Accepted solution]

If you use a formula and create a new field with the value of "1" 

using the summarize, group by that constant field and find your maxdate(). 

now you can join back on the constant and it will apply the maxdate to everything. 

cheers,

 mark

[akasubi]

Thank you!

This has done the job 🙂😃