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 s…

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

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

[image] Date Formula Help Ask for Help Here is a loom that may help get you started without doing anything too fancy. This uses a second table using the query column to bring in bills that fall within the date range. Again, not a full solution but might get y…

@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

Filtering by Date Range - combined fixed and custom ranges

Project Showcase

ThinhDinh January 24, 2024, 11:42pm 4

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

Topic		Replies	Views
Query data using two date columns Ask for Help	3	171	December 20, 2023
Filtering data based on month from Multiple columns Ask for Help	17	437	January 25, 2024
Sales Dashboard: Dynamic Date Filtering with Single Computation Table - Query vs Relation Approach Ask for Help	6	61	February 2, 2026
Date range filtering not working Ask for Help	2	144	January 23, 2024
Date Ranges Ask for Help	2	189	November 19, 2023

Filtering by Date Range - combined fixed and custom ranges

Related topics