Unanswered

Sort not working property with DateTimeValue

(0) Share

Report

Posted on by YamiteKudasai

195

Hi Everyone,

Good day!

I would like to ask for your help how to solve this issue. I use Sort Filter function. The date is sorting correctly but the time, AM and PM was not sorting properly.

DateTimeValue(NewIncidentDate) >= DatePicker_StartDate.SelectedDate && 
DateTimeValue(NewIncidentDate) <= DatePicker_EndDate.SelectedDate

The output is:

I found also if you add "0" or 0 example on time like 3:28 to 03:28 the time sorts properly. But how to achieve this?

It should have time 7/1/2022 1:45 AM, 7/1/2022 2:00 AM, 7/1/2022 3:28 AM, 7/1/2022 10:00 should be the proper order.

Thanks in advance for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @YamiteKudasai :
I tried to replicate on my site but sorting is working correctly for the Date Column.
Can you please verify once if your Column is of type 'Date time' only?

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report
Copy link

Link copied!

Hi @theapurva ,

Good day!

The picker is just in date. But the value in NewIncidentDate is in format 07/1/2022 10:00 AM something like this. So any solutions I can sort the result based on date and time?

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,
Could you please con, firm what is your database? Is it SharePoint?
If it is SharePoint, NewIncidentDate column should be of type Date and time then only it will work.

You can change the Column type to Date and Time but you may lose the timing and may need to manually fill it for the first time after you change the column type.

Also, make sure to select the 'Date and Time' format setting like above screenshot while changing the column type.

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report
Copy link

Link copied!

The datasource is sql

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @YamiteKudasai ,
Understood.
Please convert your column to datetime in Items formula as below:

Sort(Filter(YourTableName,yourfilters),Text( DateTimeValue( NewIncidentDate ), "dddd, mmmm dd, yyyy hh:mm:ss.fff AM/PM" ), Ascending)

this> Text( DateTimeValue( NewIncidentDate ), "dddd, mmmm dd, yyyy hh:mm:ss.fff AM/PM" ) will correctly sort the data as it is converting it to DateTime value

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @YamiteKudasai

Did that formula work for you?

Was this reply helpful? Yes No