Querying date intervals in the Common Data Service

Querying date intervals in Microsoft Common Data Service, Power Apps and Dynamics 365 is not always possible using Advanced Find nor is it as easy as working with plain SQL.

TL;DR – with FetchXML this is quite possible!


Have you ever wanted to tell your CRM (CDS, D365 etc.) things like:

Show me all opportunities
with Estimated Close Date
exactly 90 days from now!

Well, today a…

Continue Reading Jonas Rapp’s Article on their blog

Querying date intervals in the Common Data Service ⋆ The Dynamics 365 Trenches

TL;DR – with FetchXML this is quite possible! Have you ever wanted to tell your CRM (CDS, D365 etc.) things like: Show me all opportunities with Estimated Close Date exactly 90 days from now! Well, today a colleague of mine wanted to know if that was possible.

Blog Syndicated with Jonas Rapp’s Permission

Author: Jonas Rapp ᴹᴠᴾ ??

Share This Post On