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
More About This Author
Array
- Dyn365CE20 March 2024FetchXML improve for us to achieve more
- Dyn365CE27 February 2024Follow Microsoft to trigger plugins by Bulk Operations
- Dyn365CE11 February 2024More work ➡️ More features
- Dyn365CE5 November 2023Missing XrmToolBox.PluginsStore – read and fix it here!