web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How do I make an advan...

Finance | Project Operations, Human Resources, ...

Answered

How do I make an advanced search with X last months and get full months?

(0) Share

Report

Report

Posted on by Bjornar Hallset

5

If I make an advanced search now with criteria Opportunities Created On Last 4 months I get all opportunities created from Nov 11 2020 an until today. Today is Mar 11, 2021.

How can I make criteria to get all the opportunities created in the whole November as well, or more exactly I want all opprtunities created in the 4 last months and this month?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

André Arnaud de Cal... 306,825 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Bjornar,

You can use some commands in the query ranges to calculate date ranges. docs.microsoft.com/.../advanced-filtering-query-options

You can use the MonthRange method on a date range like: (MonthRange(-4,0))

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

SajeedMullaji 698

#2

Martin Dráb 327 Most Valuable Professional

#3

CU10121822-0 320

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans