Unanswered

analyze data in a range between two dates

(0) Share

Report

Posted on by gioce

Hi, I have a problem with data extraction, when I have to analyze data in a range between two dates and my database exceeds 2000 records I attach the script that I made and that does not extract data.

Filter('[dbo].[USR_APPUNTAMENTI]';Value(DATAAPP)>=Value(Label38.Text); Value(DATAAPP)<=(Value(Label5_1.Text)))

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

What is the structure of your datefield "DATAAPP" in SQL.
Also I suggests using datefield in powerapps instead of just a textbox

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
gioce 90 on at

Like
a
(0)

Report
Copy link

Link copied!

the dataapp field is equal to 20200407 my data search must be between 20200407 and 20200414

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

It has to do with the format of the SQL Date compared with date in the label:
Filter('[dbo].[USR_APPUNTAMENTI]';DATAAPP>=Value(Text(Label38.Text;"[$-en-US]yyyymmdd"))&& DATAAPP<=Value(Text(Label5_1.Text;"[$-en-US]yyyymmdd")))

You can also replace the Labels with DatePickers and use:
Filter('[dbo].[USR_APPUNTAMENTI]_4';DATAAPP>= Value(Text(StatDatePic.SelectedDate; "[$-en-US]yyyymmdd"))&&DATAAPP<= Value(Text(EnddDatePic.SelectedDate; "[$-en-US]yyyymmdd")))

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
gioce 90 on at

Like
a
(0)

Report
Copy link

Link copied!

unfortunately from error on the dataapp field. What could it be? I attach image

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

In your SQL Table what is the name of the datecolumn?

Was this reply helpful? Yes No
gioce 90 on at

Like
a
(0)

Report
Copy link

Link copied!

DATAAPP (VARCHAR, 😎
I ATTACH THE IMAGE

Was this reply helpful? Yes No
gioce 90 on at

Like
a
(0)

Report
Copy link

Link copied!

You would have a solution to advise?

Was this reply helpful? Yes No