65.9K
CodeProject is changing. Read more.
Home

Microsoft Dynamics CRM Advanced Find - Retrieve Records with a Date on or After Today

Sep 3, 2024

CPOL
viewsIcon

1705

Advanced Filter using the Date criteria - Today Date and after

Problem

In the Advanced Find, there's no option to set a filter for date fields to specify "Today and after." For instance, if you're looking to retrieve all active contracts that will expire on or after today, you can't directly set these criteria in the filter.

Solution

You can combine two criteria: one for expiry dates that are today and another for expiry dates within the next X years. See the screenshot example below.

Expired Date = Today OR Expired Date = Next X Years where X = 100? I tested this, and it is working as expected.