Share
Report
134The code below resulted in a delegation warning.
Filter('Dataverse Name', 'Minimum date calendar'.SelectedDate < DateValue('Created On') && DateValue('Created On') < 'Maximum date calendar'.SelectedDate)
The delegation warning is caused by the having 'Created On' nested within two functions the inner most function trying to convert it from a DateTimeValue to just a date format.
The code below is an alternative version I tried to avoid the delegation warning. Here instead of trying to convert the 'Created On' to a date format I am trying to convert the selected date to a DateTimeValue.
Filter('Par Numbers', DateTimeValue('Minimum date calendar'.SelectedDate) < 'Created On' && 'Created On' < DateTimeValue('Maximum date calendar'.SelectedDate))
But it did not seem to work as the table did not populate the gallery.
DateTimeValue('Minimum date calendar'.SelectedDate) = 1/1/2022, 12:00:00 AM
The values in the 'Created On' column are in the form 4/8/2022 12:55 PM
1/1/2022, 12:00:00 AM and 4/8/2022 12:55 PM might not be comparable due to the function that converts date to DateTimeValue seems to put a comma into it.
All responses (
Answers (
