Solved

Sharepoint 2010 calculated column help

Posted on 2013-01-16
2
847 Views
Last Modified: 2013-01-16
OK, I have somebody just come ask me if I can add a calculated column to do the following to one of their sharepoint 2010 lists....

Existing column called ReportPeriod, Single line of Text, input mask of "\d\d\-\d\d\d\d"

So field always contains something like "02-2013"

They would like a single calculated field adding that will display the NEXTreportingPeriod, based on 12 periods per calendar year.

So in the above example, the NextReportingPeriod will be "03-2013"

Must handle "12-2013" giving "01-2014"

Anybody give a single formula for this?

Thanks in advance, i hope,

Neilsr
0
Comment
Question by:Neil Russell
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 38782398
Hi,

please try this one:
=IF(ISBLANK(ReportPeriod),"",TEXT(DATE(YEAR(ReportPeriod),MONTH(ReportPeriod)+1,1),"mm-yyyy"))

Open in new window


HTH
Rainer
0
 
LVL 37

Author Closing Comment

by:Neil Russell
ID: 38782530
Spot on, saved me the time :P
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now