web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps [Bug Report] Date Comp...

Power Apps

Answered

[Bug Report] Date Compare > Equal or Less Equal a date doesn't work in Collect Filter

(0) Share

Report

Report

Posted on by fgu3029

76

1. Normal Date compare is OK, for example:

DateValue("2024/04/01") <= DateValue("2024/04/01")

2. One dataverse table(CheckWorks) with date column(CheckWorks_Date), for example:

CheckWorks>CheckWorks_Date, DateType = DateTime & Date Only, cantains 2 Values as following:

2024/4/1,2024/4/2

3. I want to grep: 2024/04/01, so I Filter it.

ClearCollect(
_test1,
Filter(
CheckWorks,
CheckWorks_Date <= DateValue("2024/04/01") // ★★★NG, u can't grep 2024/04/01

CheckWorks_Date < DateValue("2024/04/02") // ★★★OK, now u can grep 2024/04/01

)
)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!
@fgu3029

My guess would be that the issue is related to the Time portion of your Date Values. You'd need to double check that.

You could try using the TimeValue function to check each side of the filter equation. You could also try wrapping your field in DateValue, eg

DateValue(CheckWorks_Date) <= DateValue("2024/04/01")

However, this may cause a Delegation error - not sure as I don't use DataVerse

Was this reply helpful? Yes No
fgu3029 76 on at

Like (0)

Report
Copy link

Link copied!

Thank u for reply. Tried, Add DateValue in left side of eaqul operator doesn't work.
Hope ms can see this bug report.

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!
@fgu3029

Did you test Time for each side? eg

TimeValue( First(CheckWorks).CheckWorks_Date ) // versus TimeValue( DateValue("2024/04/01") )

I suspect these are different??

Was this reply helpful? Yes No

Join the conversation