Solved

Sharepoint Max date with criteria

Posted on 2016-08-30
2
82 Views
Last Modified: 2016-11-18
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!
0
Comment
Question by:boukaka
2 Comments
 
LVL 6

Accepted Solution

by:
DPatel earned 500 total points
ID: 41892714
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
 

Author Closing Comment

by:boukaka
ID: 41892999
THank you!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question