News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Comparing Date Values ...

Microsoft Dynamics CRM (Archived)

Comparing Date Values From Two Different Entities

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello,

In a workflow, can I compare the created-on date of related records in separate entities and then update the status on one of them? I’m trying to write a workflow that will change the status reason of a lead when the created-on date of a related entity record is different from the lead created-on date. For example, if the lead created on date is less than my custom entity record created on date, then change the lead status reason. I’ve been trying write a workflow to do this without success. Can this be done?

Thanks so much!

David

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

ashlega 34,475 on at

Like (0)

Report

RE: Comparing Date Values From Two Different Entities

Hi David,

you can't compare fields in the workflows.

Either try creating a calculated field and use it in the condition, or develop a custom workflow activity to do the comparison and to return a boolean value, for instance:

msdn.microsoft.com/.../gg309745.aspx

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans