How To: Using SharePoint Calculated Columns to Display Current Month List Items
1. create two computed columns (both calculated columns return Date Only values):
a. Created First Day Of Month
i. =DATE(YEAR([Created]),MONTH([Created]),1)
b. Created Last Day Of Month
i. =DATE(YEAR([Created]),MONTH([Created])+1,1)-1
I then added the below filters to view:
Real quick before I forget:
Got the following error day on our Development Sharepoint 2010 server when I attempted to delete a Web Application.
“The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT:0x80131040)”
Did an IISRESET on the application server and was able to delete
I believe this was because I was making changes to the web application and maybe it wasnt in sync with the DB?
Today I needed to find what templates were being used by each sharepoint site. The problem was related to exporting and importing sites between servers where we had some old sites that were using old templates (Fab 40 templates) that I didn’t want to install on the new server.
So I found the site using this command:
[code]stsadm -o enumallwebs [/code]
which told me which site was using the PROJSING template. I then was able to delete this site, export and import to the new server.
Let me just say, if you are not using ULViewer or don’t have it in your toolkit .. you should.
What it does: You know that cryptic error message you get in sharepoint .. come on, you know ..the Correlation ID: alksdlkjf-234l3245-0sllksdf-234234. Yeah that awesome error that tells you exactly what is wrong (not)! Well the ULViewer will shed some light on what is happening on your site when that error is generated.
So jump over to your Web Front End server and fire up ULViewer. Select File, Open, ULS Logs. Now Bring up the browser and reproduce that error. Jump back to ULViewer and press pause. Scroll up and look for the event code. You see it … now read the details.
I have found that 4 out of 5 times (that’s the tv version of math, not the scientific) that it will actually tell you what is wrong, either a missing file, missing feature .. etc.
Now use it .. and use it often.
Here is a simple PowerShell Command to list all databases used in SharePoint
[code]Get-SPDatabase | Sort-Object disksizerequired -desc | Format-Table Name | out-file c:\databases.txt[/code]