Converting From SPSystemTime From A Reference Date

If you are working with SPSystemTime struct you will have run into this. Here is a utility method that makes it really easy to get around:

public static DateTime ConvertSPSystemTimeToDateTime(SPSystemTime st, DateTime refDate)
{
if (st.Month == 0)
{
return DateTime.MinValue;
}
DateTime time = new DateTime(refDate.Year, st.Month, 1);
DayOfWeek week = (DayOfWeek) Enum.ToObject(typeof (DayOfWeek), st.DayOfWeek);
if (time.DayOfWeek > week)
{
time = time.AddDays((7 - (time.DayOfWeek - week)));
}
else if (time.DayOfWeek < week)
{
time = time.AddDays((week - time.DayOfWeek));
}
time = time.AddDays((7*(st.Day - 1)));
while (time.Month > st.Month)
{
time = time.AddDays(-7.0);
}
return time.Add(new TimeSpan(st.Hour, st.Minute, 0));
}

Applications	WebParts	Security Components
SharePoint Field Diff And Copy Utility * Written In January, 2012 SharePoint Security Scanner * Written In January, 2012 SharePoint Kerberos Buddy * Written In Feburary, 2011 BioPoint: SharePoint Biometric Authentication * Written In September, 2007 SharePoint List Security Migrator * Written In August, 2007 SharePoint Anti-Keylogger™ * Written In April, 2006 S.M.A.R.T SharePoint™ * Written In May, 2006 SharePoint Sentinel™ * Written In June, 2006 SharePoint Scrubber™ * Written In July, 2006 SharePoint Safeguard™ * Written In August, 2006	SecureSilverlight For SharePoint * Written In January, 2010 Simple Rollup WebPart For SharePoint * Written In Novemember, 2009 SimpleChart For SharePoint * Written In December, 2009 SimpleSecurity For SharePoint * Written In June, 2009 CrytoCollaboration (Encryption) * Written In June, 2007 Sample AJAX Rotator WebPart * Written In July, 2007 Sample SharePoint Redirector WebPart * Written In August, 2006 WFE Server Name WebPart * Written In January, 2006	PDF IRM Protector * Written In December, 2010 ADAM Role Provider * Written In February, 2007 Universal Provider Framework * Written In April, 2007

Articles & Research