web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Date filter not working

Power Apps

Unanswered

Date filter not working

(0) Share

Report

Report

Posted on by NSC7

15

Hi All,

I am creating a power app and for one of the Text box I have to get data from SQL table. I am using below formula to get all the Inv on a particular day. Date_Pulled Column has data type Date. When I put DateValue(Date_pulled)=DateValue("2022-07-01") condition in the filter I don't get any number but data is present in the SQL table.

Sum(Filter(ARinv,Dept=Dept_Combo.Selected.Dept_code,Prdfamily=Upper(PrdFamily.Selected.PrdFamily),
DateValue(Date_pulled)=DateValue("2022-07-01")),Inv_hand)

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@NSC7

If Date_pulled is a date type, then you don't need to use a DateValue on it...it is already a date value.

Please consider changing your Formula to the following:

Sum( Filter(ARinv, Dept=Dept_Combo.Selected.Dept_code, Prdfamily=Upper(PrdFamily.Selected.PrdFamily), Date_pulled = Date(2022, 7, 1) ), Inv_hand )

I hope this is helpful for you.

Was this reply helpful? Yes No

Join the conversation