Unanswered

Less than or Equal(<=) is not working correctly on date column filter

(1) Share

Report

Posted on by Community Power Pla...

Hi Developers,

I have a requirement to fetch the most recent dated record based on a date. The parameter date, I am passing it from a dropdown and I am passing only the date so by default the time is 12:00 AM and the Date is 1st Sep 2023.

I have put the condition as Date<=dropdown2.selectedDate, so it should fetch me the items even if it has Date column value as 1st Sep 2023 12:00 AM, but it is not fetching those records.

For your reference I have added few screenshots to give more clarity on the issue, please share your thoughts why it is not able to evaluate the =(equal) operation in <= operation.

Please share your insights on this.

**I have added additional attachments in the first comment

Categories:

Power Query

DataWithoutDateFi...

PassedDateParamet...

DateAfterDateFilt...

I have the same question (0)

All responses (4)

Answers (0)

Community Power Pla... on at

Like (0)

Report

PowerQuery.PNG

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

HI @RezaDorrani ,

Can you please check this thread and let me know what could be the resolution?

Thank you

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @AhmedSalih - could you please us here on how to resolve this? Is this an issue with Dataverse Date/Time columns?

Was this reply helpful? Yes No
Stefanos-TITAN 2 on at

Like (0)

Report

In case you need to filter the date column entries in a SharePoint List, you also need to consider about the exact entry time.

Thus, if you need to take all the list items before a specific date, you must use the following function in your case:

<= DateTimeValue(Text(Dropdown2.Selected.'Start Date') & " 23:59:59")

Was this reply helpful? Yes No