Friday, January 27, 2012

SharePoint Calculated field - Compare 3 Date columns

SharePoint Calculated field - Compare 3 Date columns
The logic
if ([Revised Due Date] = "")
set val = [Chartered Due Date]
else if([Chartered Due Date]="")
set val = [Requested Due Date]
else if([Requested Due Date]="")
set val =" NA")
the formulae
=IF(OR([Revised Due Date]<>"",[Chartered Due Date]<>"", [Requested Due Date]<>""), MAX([Revised Due Date],[Chartered Due Date]
,[Requested Due Date]), "NA")

Thursday, January 26, 2012

Getting XML Data From a SharePoint List


  • {0} – The URL to your site.  This could be the root web or a child site.
  • {1} – The GUID for your list. 
  • {2}- The GUID of the view - optional