web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter by data

Power Apps

Answered

Filter by data

(0) Share

Report

Report

Posted on by Giovanni1

Hi all, in my sql databae, I have a field called DATAPROT char (8) which identifies the date 20220101. In my app, I would like to filter the DATAPROT field> = 20220101. But by doing this, it gives me a message that I must use a date, number, or other field. If instead filter DATAPROT = 20220101, it does not give an error. Could you give me some help? Thank you in advance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Giovanni1 on at

Like (0)

Report
Copy link

Link copied!

SortByColumns( Filter( USR_CLIFO_MOVIMAG_VIEW; CODICE <> Trim("C00001")And DATAPROT>=Label38_2.Text); "DATAPROT"; Ascending )

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,974 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Giovanni1 ,

Try this

SortByColumns( Filter( USR_CLIFO_MOVIMAG_VIEW; CODICE <> Trim("C00001") And DATAPROT>= Value(Label38_2.Text) ); "DATAPROT"; Ascending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation