boukaka
asked on
Sharepoint Max date with criteria
I need to create a calculated field on sharepoint 2010 that also uses 2 criteria in it's formula. I need to find the Max Date of a list of items where the Code is the same and the Year is the same.
The first 3 rows below would be grouped and the max date of 2/5/2017 would be returned in the calculated field and the last 2 rows would be grouped and the max date of 9/1/2017 would be returned.
Code Year Date
AIS 2016 1/20/2016
AIS 2016 12/15/2016
AIS 2016 2/5/2017
AIS 2017 7/5/2017
AIS 2017 9/1/2017
I'm also using InfoPath so perhaps a repeating table could be leveraged? I don't know how though.
Does anyone know how this could be done?
Thanks!
The first 3 rows below would be grouped and the max date of 2/5/2017 would be returned in the calculated field and the last 2 rows would be grouped and the max date of 9/1/2017 would be returned.
Code Year Date
AIS 2016 1/20/2016
AIS 2016 12/15/2016
AIS 2016 2/5/2017
AIS 2017 7/5/2017
AIS 2017 9/1/2017
I'm also using InfoPath so perhaps a repeating table could be leveraged? I don't know how though.
Does anyone know how this could be done?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER