Date is not filtering correctly between two dates

(0) Share

Report

Posted on by oappdev

901

Happy Monday! Please let me know what l' m missing or doing wrong. When I filter the dates, is out of order somehow.

Data source: Excel in OneDrive

Date time zone: Local

Here is my collection.

ClearCollect(
 colUserTemp,
 AddColumns(
 Table1,
 "First Name",
 first_name,
 "Last Name",
 last_name,
 "Company Name",
 company_name,
 "Today Date",
 Text(Date,"[$-en-US]mm/dd/yyyy")
 )
);

Gallery - Items Property:

Filter(
 colUsersTemp,
 DateValue('Today Date') >= dteStart.SelectedDate,
 DateValue('Today Date') <= dteEnd.SelectedDate
)

When I check the collection is showing the first three as "12/31/2020".

Excel

As always thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

AsanKani 710 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi, @oappdev

i think it's view in "mm-dd-yyy" right ?

So you can your collection formula...

Text(Date,"[$-en-US]dd/mm/yyyy")

you can try this.. let me know your problem is resolved or not?

I think, I'm understand right.. ?
Thank you..

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi@oappdev,

Based on the issue that you mentioned, do you want to display the correct date in Power Apps?

Could you please tell me that if you format the Date column as a Date format rather than a general column?

Actually, a formatted Date column has difficulty to display a correct date data that is a known issue in Power Apps. Generally, we recommend to create a general column to store the date which is a more efficient way.

I have a test on my side that creating a General column to store the date is the key to your problem.

1). Please recreate a general column and copy-paste your date column date to it.

2). Based on the before preparation, you should modify your ClearCollect() formula as below:

ClearCollect( colUserTemp, AddColumns( Table1, "First Name", first_name, "Last Name", last_name, "Company Name", company_name, "Today Date", Date ) );

3). Please modify your Filter() formula as below:

Filter( colUserTemp, DateValue('Today Date',"en-US") >= DatePicker1.SelectedDate, DateValue('Today Date',"en-US") <= DatePicker2.SelectedDate )

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No