Link to home
Start Free TrialLog in
Avatar of boukaka
boukakaFlag for Canada

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!
ASKER CERTIFIED SOLUTION
Avatar of D Patel
D Patel
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of boukaka

ASKER

THank you!