Filtering by Date Range - combined fixed and custom ranges

I’ve been playing around with different techniques for filtering records by date range, and have managed to develop a method for combining a set of fixed date ranges together with an option for setting a custom date range.

It’s a little complicated, but not too bad :wink:

If anyone would like to see how this is done, let me know and I can probably put together a tutorial.

9 Likes

@Darren_Murphy

I’d like to see how it’s done!

1 Like

Hey @Darren_Murphy could you please let me know as to how you achieved this? or pass me tutorial link?

This might help to get you started with a query column, which was not available when Darren made the feature above, I believe.

1 Like

@ThinhDinh thank you for responding. I was able to get the data from one table.

But my dilemma is how do I get value from another table?

I need data accessed from multiple tables to check for the date range.

Could you please advise me?

Thank you in advance