Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1 Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I am trying to create a dynamic view which filters my results for the next three months.
The result I'm aiming for is
Quotes valid for the next 3 months
So today is April 11
My search should include April, May and June
Now as seen in the Screen, this month and the next is not an issue.
But Adding the filter Option "Next X months" does not give the correct results as it filters the results for the next 3 months starting from April 11 and not April 1.
Any hints on how I could apply this filter? The idea is to create a rolling forecast.
This is by design, its checking current month and in addition number of months you put. If you need from particular date then you can pass date and use "on or after" and "on or before"
thanks for your reply.
The way you Display the results works fine of course. But this would have to be readjusted each time. Im looking for a dynamic way to apply the exact filters that you put.
How about using nextXDays(90) instead of nextXmonths(3)
Yes you can do this by next 90 days.
Hey Abby thanks for your reply.
That would be a dynamic solution yes, but does not filter for my criteria to view the current month and the following two.
The commanc nextXDays would only give me the next three months starting from today
I'm not entirely sure I understand on this 'does not filter for my criteria to view the current month and the following two.'
So you want to show Quotes Valid Until (Date) in next 90 days or this month, is it correct?
Quotes Valid Until next 90 Days
Quotes Valid Until this month?
Read your original post a bit more. So you want always 3month time span in current, next, next+1 month, correct? I don't it can be achieved by advanced find query.
Please see here and read the last paragraph at the bottom, though the article is written in 2012 I think it's still true:
Next X Months: This operator does not use the calendar year. It includes all values starting now and until the same calendar day on the next month (inclusive). E.g. if it is 3:30PM on August 3rd then “Next 1 Months” includes all values between now (3:30PM) and September 3rd (until 11:59PM). When X == 1, this is NOT the same as “Next Month”. Also note that when you have DateTime fields without a time component, the time will usually be se to 12AM (hidden) so this operator would not include today in that case.
Next 3 Calendar Weeks/Months: Unfortunately you cannot build such a query from DateTime fields. You would have to either store the week/month in a separate numeric field or otherwise build a report that applies additional Datetime expressions to filter the results. CRM only supports filtering by calendar week/month for last, this and next week/month. (same applies to year).
thanks for your detailed reply!
Yes I'm trying to create a report for the next three months to the the overall volume of for example quotes or orders.
Thanks for the info I will continue to look for a workaround here
No worries, let me know if you find a better way!
Business Applications communities