Hello all,
I am looking for a method where i can query records based on a date fields that is on or before last month. meaning, if i run the query today, the 31st of July, it should pick up all records where the date filed is within or before last month, which is June.
I know this isn't straight out of the box within Dynamics, unless i am not looking in the correct areas. Is this possible with FetchXML?
Thank You in advance!
Leibish Ringel
*This post is locked for comments
Hi,
From where you are planning to run the fetch. I assume it must be some custom code. If yes, then why can't you build the date and then pass it to the fetchxml. For example, below code retrieves account created on last month and older.
========
using (service = new OrganizationServiceProxy(new Uri(_organizationURI), null, _credential, null))
{
var currentDate = DateTime.Now;
var firstDayOfCurrentMonth = new DateTime(1, currentDate.Month, currentDate.Year);
var lastDayOfPreviousMonth = firstDayOfCurrentMonth.AddDays(-1);
var fetch = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
<entity name='account'>
<attribute name='name' />
<filter type='and'>
<condition attribute='createdon' operator='on-or-before' value='{0}' />
</filter>
</entity>
</fetch>";
fetch = string.Format(fetch, lastDayOfPreviousMonth.ToString("yyyy-MM-dd"));
var reults = service.RetrieveMultiple(new FetchExpression(fetch));
}
=====================
Hope this helps.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
