Dynamics 365 CommunityForums Dynamics 365 general forum Business rule or workf...

Business rule or workflow to set the most recent date from 3 other fields into a new field

(0) Share

Report

Posted on by BritB

I have a date for reporting called "reporting date",want to look at 3 other fields and pick the most recent date to populate here.
Ex: today is 2/26/19
Date 1: 2/21/18
Date 2: 10/15/18
Date 3: 2/15/19
Reporting Date would be populated with 2/15/19

How can this be done?

All responses (2)

Answers (0)

BritB on at

Like (0)

Report

RE: Business rule or workflow to set the most recent date from 3 other fields into a new field

thank you, any direction on how to do this?
Suggested answer

Adrian Begovich 1,025 Super User 2025 Season 1 on at

Like (0)

Report

RE: Business rule or workflow to set the most recent date from 3 other fields into a new field

Hi BritB,

I would implement this with JavaScript or a Plugin. Your code will need to retrieve the values of "Date 1", "Date 2", and "Date 3" and compare the values to find the most recent date. Once you have the most recent date it is just a matter of populating the "Reporting Date" with the most recent date.