Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Cases were closed on d...
Customer experience | Sales, Customer Insights,...
Suggested answer

Cases were closed on date is earlier than created on date.

(0) ShareShare
ReportReport
Posted on by Shane_DLR 3
I have found some Dynamics CRM cases were the closed on date is earlier than created on date. So I've two queries.
 
1. Has anyone seen this before and have any ideas how it might have happened? The users can't manually edit/enter the date when they deactivate them. The cases I have found don't have any processes running that could do this.
 
2. I'm trying to do an advanced find to find all the Cases like this. I can't figure out what combination of Closed On and Crearted On I need to do. Ideally I want to be able to do Closed On - Before - Created On but that isn't an option.
 
Thanks
  • Shane_DLR Profile Picture
    Shane_DLR 3 on at
    Cases were closed on date is earlier than created on date.
    Thanks Ray it is possible there was some data migration job run before my time. The lastest case with these dates out of order, is from 2022. If I can't find any recent ones, I'll chalk it up to that.
  • Suggested answer
    Ray Profile Picture
    Ray 1,505 on at
    Cases were closed on date is earlier than created on date.
    For the first question, assigning a value to the Created On field is possible. We can achieve this by assigning a value to the Record Created On field. It is often used in data migration and data initialization, and it may also used in data import.
    For the second question, the query condition of field-to-field comparison is not yet supported at the UI level, so there is no way to directly find the data through Advanced Find. You can consider adding a new Boolean type calculated field. This field is used to mark the comparison result of the two time fields, and then use the calculated field as a condition in Advanced Find to find the required data. You can also use something like Power Query that supports fetchXml queries to achieve this.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans