Filtering data using date picker cause problem

(0) Share

Report

Posted on by Lakmini

I'm using the below code on a gallery to filter data using various dropdown filters. There are 3 dates range filters:

Changedate_1: when I select 13/5/2024, I receive 2 records instead 5 records for that date as an example.

Date	Num of Records	Num of Records when I select the Date
5/9/2024	1	1
5/11/2024	1	0
5/12/2025	1	0
5/13/2026	5	2
5/14/2027	5	3
5/26/2028	2	2
5/27/2028	4	4
5/28/2028	2	2
5/30/2028	2	2

StartDateTimer_3: when I select Start Date 13/5/2024, I receive all correct records (5 records for 13/5/2024, and 5 records for 14/5/2024,…..)

EndDateTimer_3: when I select End Date 14/5/2024, I receive only 8 records instead 10 records (5 records for 13/5/2024 and 3 records for 14/5/2024,….); But, if I select End Date 15/5/2024, I receive 10 records (5 records for 13/5/2024 and 5 records for 14/5/2024,….)

Filter(

'FAK-ACM-Records',

(Station = drpStation_2.Selected.Value || drpStation_2.Selected.Value = Blank()) && (EmpID = drpEmpId_1.Selected.Value || drpEmpId_1.Selected.Value = Blank()) && (IssuedTo = Issued.Selected.Value || Issued.Selected.Value = Blank()) && (Date = Changedate_1.SelectedDate || Changedate_1.SelectedDate = Blank()) && (Date >= StartDateTimer_3.SelectedDate || StartDateTimer_3.SelectedDate = Blank()) && (Date <= EndDateTimer_3.SelectedDate || EndDateTimer_3.SelectedDate = Blank())

)

Also, when I checked the data below, I found when I create the record for 5/28/2024 @ 12:08:30AM, it saved my date as 5/27/2024; but no problem for records created on 5/30/2024 @ 12:27:10AM and @ 12:28:35AM.

How do I alter this to make it work correct?

Thanks for your support.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Lakmini 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I need help please, It's 2 days now and I can't find my mistake.
Thanks a lot for your support.
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Lakmini ,

Your problem seems to be the data, not the filter (which seems fine to me).

Filter( 'FAK-ACM-Records', ( Station = drpStation_2.Selected.Value || drpStation_2.Selected.Value = Blank() ) && ( EmpID = drpEmpId_1.Selected.Value || drpEmpId_1.Selected.Value = Blank() ) && ( IssuedTo = Issued.Selected.Value || Issued.Selected.Value = Blank() ) && ( Date = Changedate_1.SelectedDate || Changedate_1.SelectedDate = Blank() ) && ( Date >= StartDateTimer_3.SelectedDate || StartDateTimer_3.SelectedDate = Blank() ) && ( Date <= EndDateTimer_3.SelectedDate || EndDateTimer_3.SelectedDate = Blank() ) )

The problem is that your post possibly confuses this so you need to clarify if the filter is actually returning what is in SharePoint correctly, then it can be disregarded. I would normally suggest that the day before is a classic Time Zone conflict between the local user and the SharePoint site, but you have pointed out that other entries within an hour difference work fine.
You also need to post how you populate field_1 (I assume this is the Date field)
Lakmini 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Mr. Warren for your reply. Please see attached file

Thanks Mr Warren....
Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Lakmini ,

That does not help me with the questions I asked - is your SharePoint Data correct and the issue is with the filter, or is the filter correct and the issue is with the data that is written ? Also how do you write the data to the Date field ?
Lakmini 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Warren,
the issue was with the SharePoint Data. The problem has been solved.