Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / Query on 2 date fields...
Dynamics 365 general forum

Query on 2 date fields against each other, is it possible?

(0) ShareShare
ReportReport
Posted on by BritB

I have a user wanting to set up a report. We have an active date and a contract date on account form.

The query should be something like this. 

All  accounts where Active Date < (before) Contract Date and Contract Date < (before) 3/11/2015

Is that possible to query in advanced find? thoughts?

Categories:
General
  • BritB Profile Picture
    BritB on at
    RE: Query on 2 date fields against each other, is it possible?

    actually, this is correct, but I can figure it out if someone can help with whichever:

    All accounts where active date (is before) contract Date and Contract date (is after) 3/11/2015

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans