- About us
- Services
- Skills
- Web Development
- ColdFusion Development
- SharePoint Development
- Classic ASP Development
- ASP.NET Development
- Modern ASP .Net Development
- DotNetNuke Development
- Java/JSP/servlets Development
- Python Development
- PHP Development
- Perl Development
- Ruby on Rails (RoR) Development
- Lasso Development
- Real Basic Development
- Google API Integration Services
- Mobile Development
- Database & Client server Development
- Plug-in Development
- Reports/BI Development
- Automated Testing
- QA/Testing Skills
- Domain-based Testing
- E-Commerce Development
- CMS Development
- Desktop Development
- RIA Development
- App-based development
- Salesforce Development
- SugarCRM Development
- Dynamics GP GreatPlains development
- Dynamics SL Solomon development
- Microsoft Dynamics CRM Consulting Development
- Dynamics RMS development
- LiveCycle development
- QuickBooks development
- Drupal development
- Joomla development
- Typo3 development
- Magento development
- Dolphin social development
- Others
- Web Development
- Industries
- Knowledge
- Process
- Models
- Clients
- Career
| |
Software Technology Tips
We can use SharePoint API as well as SharePoint List web reference to update List Items. Using API it is quite straight forward as we can directly assign a DateTime object against a DateTime field in SharePoint list. But with List web reference it is not that straight forward as we need to first convert the DateTime object into the SharePoint DateTime formatted string and then assign it to the specific field.
Provided below are code samples written in C# to format an input as per SharePoint DateTime field. |
/* -- Format for Date Only Field -- */
private static String ToSPDate(String strDt)
{
if (strDt == String.Empty)
return strDt;
else
return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-dd");
}
/* -- Format for DateTime Field -- */
private static String ToSPDateTime(String strDt)
{
if (strDt == String.Empty)
return strDt;
else
return (Convert.ToDateTime(strDt)).ToString("yyyy-MM-ddTHH:mm:ssZ");
}
/* -- Build List WebReference CAML String -- */
String strCamlBuilder = "<Method ID='1' Cmd='Update'>";
strCamlBuilder += "<Field Name='ID'>1</Field>";
strCamlBuilder += "<Field Name='DateOnlyField'>" + ToSPDate(strDtInput) + "</Field>";
strCamlBuilder += "<Field Name='DateTimeField'>" + ToSPDateTime(strDtTmInput) + "</Field>"; strCamlBuilder += "</Method>"; |
Related Tags:
SharePoint
Author: Kaushik Mohanty
Related Pages
SharePoint
- Format Input for SharePoint DateTime field
- Renaming the menu items in SharePoint Site Libraries and Lists for a Specific Site
- Create List Programmatically in SharePoint
- Add Columns / Fields Programmatically to a SharePoint List
- Add, Update and Delete List Items Programmatically in Sharepoint
- Attachments in SharePoint (Part I)
- Create and Update Views Programmatically in SharePoint
- Adding an Attachment to a List Item Programmatically in SharePoint
- Programmatically creating Folders within SharePoint List
- Add Choice Field Programmatically to a SharePoint List
- How to add Server side code in SharePoint content pages
- Programatically adding a document to document library in SharePoint
- How to attach a workflow to a list programatically in SharePoint ?
- How to pass data from one webpart to another webpart in sharepoint ??
- SharePoint SPQuery Part II
- How to open a SharePoint list in Windows Explorer ??
- Changing SharePoint site locale programmatically
- How to add a menu button to a specific sharepoint list toolbar
- Fetching associated groups for a User in SharePoint using Web Service
- How to programatically get the next item ID for a SharePoint list
- More Related Tips
