Requirement:
User want to see the default values while pulling out the loan details report with the given start and end date. Where the start date should be today’s date and end date should be “12/31/8888” in a server side WebPart control. When user click on Submit button we should ensure that End date is not less than Start Date.
Read some SharePoint 2013 tutorials:
- Change SharePoint 2013 OOB List Form Column Ordering without using Code
- Delete Hidden Web Application in SharePoint 2013 using PowerShell
- SharePoint online: Ultimate tutorial guide PDF download
Solution:
We can implement this in both CSOM and c#.net. Since the requirement is to implement in a server side control. Below is the code snippet to achieve this:
SharePoint Date Control:
<SharePoint:DateTimeControl ID=”cldStartDt” runat=”server” />
<SharePoint:DateTimeControl ID=”cldEndDt” runat=”server” />
<asp:Label ID=”lblMessage” runat=”server” ></asp:Label>
C# code to populate default values:
cldStartDt.SelectedDate = Convert.ToDateTime(DateTime.Today.ToString());
cldEndDt.SelectedDate = Convert.ToDateTime(DateTime.MaxValue.AddYears(-1111).ToString());
“Convert.ToDateTime(DateTime.Today.ToString())” with this we can get today’s date in Date and Time format.
Convert.ToDateTime(DateTime.MaxValue.AddYears(-1111).ToString()) with this we get the end date as “12/31/8888”
Validation to ensure that EndDate is not less than Start Date:
Which the below code snippet we can achieve the validation.
int dtDiff = Convert.ToInt32(endDate.Date.Subtract(Convert.ToDateTime(cldStartDt)).Days);
if(dtDiff>0)
{
lblMessage.Text = “End Date must be greater than Start Date!!”;
}
Hope this helps.
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.
You May Also like the Following SharePoint Online Tutorials:
