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!
boukakaAsked:
Who is Participating?
 
D PatelD Patel, Software EngineerCommented:
Hi Boukaka,

http://www.bizsupportonline.net/infopath2007/select-minimum-date-infopath-repeating-table.htm

Replace the min function with the below :

xdMath:Max(/my:myFields/my:group1/my:group2/my:field2)]

Regards,
D Patel
0
 
boukakaAuthor Commented:
THank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.