If your data source is SharePoint then there is no way to get around delegation warning (and incomplete results) for large lists when filtering with dates.
Please reference the Delegable function, operations and column types for more information on what you can and cannot do.
So, the reality is, the only real problem you are having with that formula is that it works in one environment and not another.
Consider changing the formula to the following:
If (Month_1.SelectedText.Value = "January";
Filter ('Hours_Inverted';
'Activity date' >= Date(2018,12,25) &&
'Date of activity' <= Date(2019,1,24)
)
)
You don't need to convert your column date to text and then back to a date again. Also, the Date function will be a bit more reliable in this case.
NOW...that would only deal with the issue of working on other devices. This does NOT resolve the delegation issue.
That is going to take more work.
In order for you to be able to delegate queries/filters on that list, you will need to do it by a delegable function and column type. You could use a number or text to do this.
A solution you can use is to set up a Flow/Workflow on your list that when an item is created or changed, to have the Flow/Workflow copy the date value to a delegable column type. So, for example, you could have it copy into a number column or a string column IN THE FOLLOWING FORMAT - yyyymmdd
Now, once that is in place, you can use < or > on the numeric column without delegation issues. Or StartsWith on the text column.
Ex.
Numeric - 'Activity Date Num' - Value: 20190102
You can use 'Activity Date Num' <= Date(2019, 2, 1) without delegation issues
Text - 'Activity Date Text' - Value: "20190102"
You can use StartsWith('Activity Date Text', "201901") to return all of Jan 2019 items without delegation issues.
Admin
Apps4rent
