HOW TO: Search a date field in Microsoft Dynamics

   Words by CRM Consultancy

   on 07/10/2021 15:58:00

Tendai's Article Picture for Open Writer

Microsoft Dynamics allows its users to have several fields to their CRM. These fields can be searched in many ways by users. One field which has multiple ways in searching is the Date field. In this article we will be touching base with the ways in which users can search the date field in Microsoft Dynamics.

Let’s say a user wants to search all records in the year of 2020. When it comes to searching by Date and Year, this is not possible using the Quick View. The user is not able to search in the Quick view by inputting a date or a year as shown below.

The first option available to be able to search all records in 2020 is by applying a filter that shows all records for Last Year.


This will then bring up all the records that are available in the year of 2020. This can be done for any year through the filter option.


The filter tool is a great tool as it offers multiple ways in which users can filter from and view records.

Another way in which this can be done to give users a good experience is by using System Views. This is one aspect we applied for one of our clients who wanted an easy approach to being able to view different case types in certain years that being 2020 and 2021. This is done by building a view for records this year and another view for records last year and these will be easily accessible from system views. These can then be filtered to show certain case Types and a certain Year.


By creating these views, it will allow users to have easy access to accessing cases of a certain year and of a certain type. From the image above a user can easily access All Active Cases that are in the year of 2021.

To wrap up with System views It is a great and easy way to access certain records of a certain Year or record types by having them in a view which you can select from. However, with system views is if you are handling quite a large quantity of records and wish to have it easily accessible you could have multiple views to choose from.

Another tool which is quite common in Dynamics is the Relevance search. The relevance search will search from the Top level and will search everything within the CRM. It is mainly common for searching content and information within a certain record and will bring up that record. When it comes to searching records of a certain year relevance search will not show those records.

For example, you want to display all records for 2020 using the Relevance Search. If you input 2020 in the Search tab at the top it will only show those records with 2020 in the content but not show all records of 2020.


As noticed the Relevance search will not show all records of 2020 but will show those records that contain 2020 in the content or information.

As we can conclude with Relevance search it’s a great tool when you need to search for a record using the content within that record however it does not view all the records of that certain year or a specific year.

Further Reading

Find more of our technical articles and HOW TO Guides on the CRMCS Blog

Got any questions for The CRMCS Team?

Share this Article

Search Articles

Filter Articles

CRM Tech DocMan

Recent Articles

HOW TO: Virtual Entities in Dynamics 365 Release Wave 2 New Feature: The Columns Button HOW TO: Search a date field in Microsoft Dynamics The Relevance Search COMING SOON to Power Apps Portals HOW TO: Manage Your Dynamics 365 Database Size (Video Included) Dynamics 365 Marketing vs ClickDimensions It’s time to pause, reflect and acknowledge a new era of inclusivity and collaboration. Part 2 - How to get the most from a Technology Expert – Asset Management Hub Property & Asset Management Hub Part 1 – Balancing CRM and Asset Management Scopes - Asset Management Hub Creating a Multi-Lingual PowerApps Portal How to Set Up a Microsoft Teams Site Using DocDrive365 Microsoft Teams - Adding a Microsoft Teams URL to a Dynamics Appointment Dynamics 365 Marketing – Customer Voice Survey Not Appearing In Emails? Using SQL Management Studio to connect to the Dynamics DB Calling a Power Platform AI Builder Model via oData How to use DocDrive365 to integrate permissions between Business Units in Dynamics with Sites in SharePoint Getting started with the Power Platform AI Builder. Power Apps Portal Information Hub DocDrive365 Security: Day One - Getting Started with Dynamics to SharePoint Permissions Part 5 - Power Apps Portals: How To Connect Azure B2C With Linked-In Part 4 – Power Apps Portals: Styling Azure B2C for Power Apps Portals The 3 Phases for Using Multi-Select Option Sets in Flow with Microsoft Forms Part 3 – PowerApps Portals: Azure B2C and Power Apps Portals – User Flow for Signup and Signin Part 2 - Power Apps Portals: New Application Registration in Azure B2C for our Power Apps Portal
Contact Us

Want expert advice or a demo?

Get in touch now and see how we can help your business grow.

  • Name
  • Email Address
  • Phone Number

Understanding Your Challenges

Our strong understanding of CRM and emerging technologies within the Microsoft environment means we deliver the right solutions for you.

Proven Real-World Solutions

As a leader in the field of Dynamics solutions, our pedigree developing and delivering real-world solutions is unsurpassed.

Long Term Support

We provide support beyond our design, implementation and 'go-live' delivery using Sprints and continual updates to our AppSource apps.

CRMCS | Design by Thinktank Marketing | Citrus-Lime Limited

To improve your experience today and in the future, this site uses cookies. Read our full Privacy Policy & Cookie information here I Understand