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?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Adrian Begovich 1,027 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
BritB on at

Like (0)

Report

thank you, any direction on how to do this?

Was this reply helpful? Yes No