Solved

Sharepoint Max date with criteria

Posted on 2016-08-30
2
170 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
D Patel 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

624 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