Add new expressions to workflow - get maxdate n mindate
Hope all is well!
Is it possible to add get max and min dates from related modules in workflow expressions?
Example - Account has a 1 to Many relationship to Service Contract Dates. Account Module field looks up the max/min date from the related Service Contract Dates to determine the last/first service dates.
Account Module fields
MaxDatelookup field- 1/1/2021
MinDatelookup field- 1/1/2010
Related Service Contract records to Account
1 - 1/1/2010
2 - 1/1/2012
3 - 1/1/2018
4 - 1/1/2021
Is it possible to add get max and min dates from related modules in workflow expressions?
Example - Account has a 1 to Many relationship to Service Contract Dates. Account Module field looks up the max/min date from the related Service Contract Dates to determine the last/first service dates.
Account Module fields
MaxDatelookup field- 1/1/2021
MinDatelookup field- 1/1/2010
Related Service Contract records to Account
1 - 1/1/2010
2 - 1/1/2012
3 - 1/1/2018
4 - 1/1/2021