Customer experience | Sales, Customer Insights,...

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

(0) Share

Report

Posted on by Shane_DLR

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

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Ray 1,537 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Shane_DLR 3 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the March Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the March Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates