Announcements
Please find the attached document which describes the issue.
Hi @KS13
The SelectedDate property of a date picker returns a date object. There's no need for you to call the DateTimeValue function on SelectedDate. If you remove the call to this function, it should fix the delegation problem.
(IsBlank(FromDateNew.SelectedDate) || START_DATE >= FromDateNew.SelectedDate) && (IsBlank(ToDateNew.SelectedDate) || START_DATE <= ToDateNew.SelectedDate) && (IsBlank(LoadDate.SelectedDate) || LAST_MODIFIED_DATE = LoadDate.SelectedDate)
Hi @timl
Thanks for your quick response!! I tried doing it, it doesn't give me any delegation error but when I try filtering the gallery by selecting dates from FromDate and ToDate, it returns me an empty gallery.
Again if I replace it with below code which has DateTimeValue function, the gallery filters well by returning expected data but lots of data are missing since only max of 2000 records only are getting loaded due to delegation issue.
(IsBlank(FromDateNew.SelectedDate) || DateTimeValue(START_DATE) >= DateTimeValue(FromDateNew.SelectedDate)) && (IsBlank(ToDateNew.SelectedDate) || DateTimeValue(START_DATE) <= DateTimeValue(ToDateNew.SelectedDate)) && (IsBlank(LoadDate.SelectedDate) || DateTimeValue(LAST_MODIFIED_DATE) = DateTimeValue(LoadDate.SelectedDate))
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 70
WarrenBelz 64 Most Valuable Professional
Kalathiya 36 Super User 2026 Season 1
