Hi Kevin, there are a couple ways to solve this. The easiest way is to reshape your data so you only have one date field per row. You could do this with Custom SQL or a Union. The goal is instead of
Date Entered Date Closed 1/1/2015 1/10/2015
You end up with something like:
Date Event 1/1/2015 Entered 1/10/2015 Closed
The alternative involves data scaffolding and blending to get a common set of dates. There's a lot more info on this topic here: FAQ: Open & Close Dates. It's a tough one!
Thank you Adam
That helped me !