Filter by a date range comparing it to Todays function

[Julien2]

Hello everyone,

I want to filter the data by a date range based on two fields that I have in the table as Start and End dates.

For example:

When I filter the data I should expect to see in the power apps gallery the above two records because their Start and End date are still valid.

Currently, the only record that is showing is the Dynamics BC, I tried to use the below formula but it seems Todays() function set the time to midnight and that's the reason why the other record is not showing.

    Filter(
        'Timesheet Schedules',
        'Res. Name'.'Resource Identification' = _resid ,
        'Start Date' <=Today() && 'End Date' >= Today()
    )

I tried to format the today function to display only the Date and get rid of the time with no hope:

What should be the right formula to filter the data by the date range and display those two records?
Can please someone provide an example?

Any help is highly appreciated.

Best regards,
Julien

[Julien2]

Hi @WarrenBelz ,

I have tried the exact same formula you mentioned and below is a screenshot that still highlights under the date the delegation warning:

Maybe because we are comparing the start date (date & time) to the wNextDay as Date only?

What will be the updated formula in that case?

Thank you!

[WarrenBelz]

@Julien2 ,

I cannot test that presently unfortunately, but if that is not Delegable, there is no Delegable solution.