web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Strange issue with the output of a View

(0) ShareShare
ReportReport
Posted on by

Hi everyone

I've created a View that shows me all the records that were Modified on 4th August 2022 (i.e.today) and prior as shown below:

pastedimage1659623957935v1.png

This brings up several hundred records, including those that were modified on 4th August 2022.

However, what I really need is a View of those records that were modified ONLY on 4th August 2022. When I change the View criteria from Modified On / On or Before / 04/08/22 to Modified On / On / 04/08/22 I get no results.

Does anyone know why this might be?

Many thanks
Jon

I have the same question (0)
  • Verified answer
    Ray Profile Picture
    1,537 on at

    I guess you want to get Contacts that were modified on the date not the Contact' Modified By(user)  modified on the date? You added the "Modified On" condition in "Modified By", this will filter the User table's modified on field not the Contact.

  • Suggested answer
    PerezAguiar Profile Picture
    Microsoft Employee on at

    Hey Jon!

    I think there's an error on your query.  I can see you're showing the "Modified by (user)" (related field) and then there's a subfield "Modified on".  However, because the "modified on" is inside "modified by (user)", seems you're querying "when the user was modified" instead of "when the contact was modified".

    The "modified on" should be on level up:

    pastedimage1659681118281v2.png

  • JonClay Profile Picture
    on at

    Hey Daniel & Roy

    Thanks so much. I was confused as I couldn't see the correct Modified On when I created the View, and then realised that it was hidden from the search in the back-end.

    Best wishes

    Jon

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 55

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans