View sorted by a date and a date/time field not sorting correctly

(0) Share

Report

Posted on by MattTaylor

123

Dear PowerApps Community,

I've been having an issue with a view that sorts by two fields, the first is a date only field and the second is a date/time field. I appreciate that behind the scenes the date only field will have a time component but in theory this should be the same for all records, right?

I am sorting first by Date Completed (actualdate) and then by Date Created, my expectation would be for 3 or 4 records with the same Date Completed, the sort order should effectively be just Date Created. This is instead what I see:

You can see for the 8th March the sort is incorrect on the Date Created (far-right column).

Microsoft support tell me that this is intended behaviour and on a support environment they showed me this:

It shows different second components for my 'date only' field. They have told me that the only option is to create a pre-create plugin to set the second component to zero. This seems very odd to me, has anyone else had any experience with this or any similar issues?

Thanks in advance,

Matt

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @MattTaylor ,

That is not expected behavior in my opinion and I am in a demo tenant to try and recreate the situation and I am unable to do so...

I did the following:
1. Added a "Date Only" field to the Account called Test Date
2. Modified the Active Accounts view to sort on this date first and then create date second
3. Tried multiple updates to the fields on the Test date and the sorting always stayed appropriate for every test.
4. Created a Power Automate flow to extract the Test Date and format the output to a variable and the time is always set to 12:00:00 AM which is what I expected.

My question is did you convert this field from a Date / Time to a Date Only field? I think I have heard of issues when this is done where it maintains the time part on the fields for existing records...
https://www.inogic.com/blog/2015/07/updating-date-values-of-existing-records-after-modifying-the-datetime-behaviour-in-dynamics-crm-online-update-1/

Hope this helps. Please accept if answers your question or Like if helps in some way.

Thanks,

Drew

Was this reply helpful? Yes No
MattTaylor 123 on at

Like (0)

Report

Hi Drew,

Thanks for your reply, that's a good point and something I'll have to check - is there any way to tell if the field was changed at some point as it was before my time if it was?

It seemed bonkers to me that this was "by design", so I'm glad someone else agrees!

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @MattTaylor,

Sorry I don't know how to check if the field was changed...

Maybe Microsoft has a way to check this? Another option would be if you had an initial backup saved somewhere that you could restore to another environment but assume that is not the case...

Thanks,

Drew

Was this reply helpful? Yes No