Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

I need an "After" current day/month/year filter option for Date fields

(0) ShareShare
ReportReport
Posted on by

Hi All,

I want to create  a report of opportunities with Estimated close date in next 2 months AFTER current month.

Current filters don't have this option, can anybody please suggest a way to do this? 

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: I need an "After" current day/month/year filter option for Date fields

    Hi Bharat,

    Brilliant , thanks!

  • Verified answer
    BharatPremji Profile Picture
    2,485 on at
    RE: I need an "After" current day/month/year filter option for Date fields

    Hi,

    There is a workaround for this if your not using Fiscal Years.

    You have to change your Fiscal Year settings to be Monthly:

    5102.Capture1.PNG

    Then within Advanced Find do:

    5102.Capture1.PNG

    Regards

    Bharat

  • Community Member Profile Picture
    on at
    RE: I need an "After" current day/month/year filter option for Date fields

    Hi Temmy, thanks for your prompt response but sadly that doesn't solve my problem.

    I want an advanced view for the dashboard and not report.

    The next X months would have been ideal but it pulls current month too which we dont want.

  • Suggested answer
    Temmy Wahyu Raharjo Profile Picture
    2,914 on at
    RE: I need an "After" current day/month/year filter option for Date fields

    Hi,

    For advance find, we have Next X Hours, Days, and Month. But if you want static parameters like 2 months, I believe we don't have this.

    If you want to create a report using ssrs, you can add custom parameters and construct value from there. So your user will choose the parameter based on your created one.

    docs.microsoft.com/.../report-parameters-report-builder-and-report-designer

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
Victor Onyebuchi Profile Picture

Victor Onyebuchi 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans