datetime

CAML Query Search Between Two Date Ranges : SharePoint

|

SPSite site = new SPSite(“http://localhost:3001”); SPWeb web = site.OpenWeb(“MyWeb”); SPList list = web.Lists[“MyList”]; //RequestStartDate & RequestEndDate will be passed in mm/DD/yyyy format. //They can extend  to work with time also. string startDate = (SPUtility.CreateISO8601DateTimeFromSystemDateTime(Convert.ToDateTime(this.RequestStartDate))); string endDate = (SPUtility.CreateISO8601DateTimeFromSystemDateTime(Convert.ToDateTime(this.RequestEndDate))); SPQuery query=new SPQuery(); query.Query = “<Where><And><Geq><FieldRef Name=’Date_x0020_of_x0020_Meeting’ /><Value Type=’DateTime’>” + startDate + “</Value></Geq><Leq><FieldRef Name=’Date_x0020_of_x0020_Meeting’ /><Value Type=’DateTime’>” + … CAML Query Search Between Two Date Ranges : SharePoint

Get Date of the Monday in the Current Week

|

Please find code snippet for getting date of Monday in current week. protected void Page_Load(object sender, EventArgs e) { DateTime FirstDayOfWeek = DateTime.Now; DayOfWeek WeekDay = FirstDayOfWeek.DayOfWeek; Culture = “en-GB”; switch (WeekDay) { case DayOfWeek.Monday: break; case DayOfWeek.Tuesday: FirstDayOfWeek = FirstDayOfWeek.AddDays(-1); break; case DayOfWeek.Wednesday: FirstDayOfWeek = FirstDayOfWeek.AddDays(-2); break; case DayOfWeek.Thursday: FirstDayOfWeek = FirstDayOfWeek.AddDays(-3); break; case … Get Date of the Monday in the Current Week

Convert date from dd/MM/yyyy to MM/dd/yyyy for storing in SharePoint list or Sql Server Database

|

I was working on a custom web part that takes the date in Indian format e.g. dd/MM/yyyy while inserting the record in SharePoint custom list. But as we know that SharePoint custom list insert the date value as MM/dd/yyyy format. So it was throwing me the error for invalid string format so below is the … Convert date from dd/MM/yyyy to MM/dd/yyyy for storing in SharePoint list or Sql Server Database