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 :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Advanced Find to compa...
Microsoft Dynamics CRM (Archived)

Advanced Find to compare two attributes on the form and give me the results

(0) ShareShare
ReportReport
Posted on by sai123456 324

I have requirement to compare two date fields on the same record and give me results for those which have same date.

Eg: On the form I have Date Created and Date Opened fields

Advanced find to show results where Date Created Equals Date Opened

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Akanksha Ranjan Profile Picture
    Akanksha Ranjan 460 on at

    Hi Sai,

    Advanced Find Date field property dont give equal statement possibility.

    You can try to achieve this with some query expression or javascript function.

    Thanks

    P.S: Please mark answer as verified, if found useful.  

  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    This is one of the limitation of advanced find in Dynamics CRM .In an alternate way  you can  create additional field ("Yes/No") and  update the field using workflow , plugin , js  as par your logic and retrieve the field using advanced find.

  • sai123456 Profile Picture
    sai123456 324 on at

    Thanks Goutam!

    I need the list for this criteria on old records. Looks like the only way is retrieve using SQL query.

  • gdas Profile Picture
    gdas 50,091 Moderator on at

    Exactly , that is one options you can  access DB since you are in on-premise. If its help then you can go ahead with this approach. To see the results in  UI  I would recommend to create new field.

  • Suggested answer
    Goutham A Profile Picture
    Goutham A 2 on at

    You can't directly compare date fields in Advanced find.

    Instead, You can create a new calculated field. Please give your comparision logic inside the query for calculation and mark the value of this calculated field to true if both data fields are equal.

    Then, in Advanced find you can query using this calculated field.

    aaa123.jpg

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans