Date Filters are not working

[PoohBear]

All of sudden my app stopped working today because it uses date filters. This is extremely infuriating!! What changed and how can I fix it????

[PoohBear]

Here is my formula. This used to work fine, but filtering by Today() returns no data now. 

SortByColumns(Filter(LastN('Archive-Parking Spot List',500),EmployeeEmail=CurrentUserName.Text && 'Start Date'=Today()),"Start_x0020_Date_x0020_Text",Ascending)

[LRVinNC]

There was an update today that affected Today/Now.  See the following blog post:  https://powerapps.microsoft.com/en-us/blog/delegation-enhancements-for-lookups-today-now-and-addcolu...

[PoohBear]

If enter the formula as below (less than today) I get data. However, if I put > or = nothing comes back. If I remove the filter I can see everything including the list item for today.

SortByColumns(Filter(LastN('Archive-Parking Spot List',1000),EmployeeEmail=CurrentUserName.Text && 'End Date'<Today()),"Start_x0020_Date_x0020_Text",Ascending)

[PoohBear]

Thank you so much for giving me this link. I will try to resolve with it!

---

@LRVinNC wrote:

There was an update today that affected Today/Now.  See the following blog post:  https://powerapps.microsoft.com/en-us/blog/delegation-enhancements-for-lookups-today-now-and-addcolu...

---

[Knich]

Have you confirmed your data source Archive-Parking Spot List contains today's date and/or employee email in the last 500 records?

[PoohBear]

Yes. Even if I bump to 1000 (only 513 list items) I still get nothing

[LRVinNC]

Are you getting a delegation warning on this query?  If so, what do you have the data row limit for non-delegable queries set to in your app settings?  The default is 500 -- you can increase to a max of 2000.  If this data source has more than 2000 entries, you will never be able to return this data with this query.

[PoohBear]

So that is the issue, when I bump the Data Row limit to 2000 I get the expected result. Howerver, I am not getting a delegation warning because of the LastN in the formula. How can I change that formula so I don't run into this issue?

[Knich]

Unfortunately, I ran into delegation issues until I switeched to a SQL database for my data.