Date/Time fields from Sharepoint Library

[pmc1982]

I keep recieved the following erro when trying to use date/time field from my SP2010 library. The fields are populated from an inforpath form into SP.

 

Debug Information:
Renderer: Flash
Flash Player installed: true
Browser Information:
App code name: Mozilla
App name: Microsoft Internet Explorer
Version: 4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.3)
Platform: Win32
User agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; InfoPath.3)
Invoker: Error message

SharePoint Version: 14.0.6106.5002

ErrorLog entries:
Date: 12/17/2013 3:36:24 PM
Title: Chart settings could not be saved. Please check your connection settings and try again.
Chart Version: 1.1.7.0
Exception Method: GetColumnsToView
Exception: String was not recognized as a valid DateTime.Couldn't store <> in GSC_x0020_SENT_x0020_DATE Column.  Expected type is DateTime.
Type: Error
Stack Trace:    at System.Data.DataColumn.set_Item(Int32 record, Object value)
   at System.Data.DataRow.set_Item(DataColumn column, Object value)
   at Collabion.Charts.Business.Helpers.DataTableHelper.GroupRows(IEnumerable`1 dataRows, GroupByOperation groupBy, ChartConfiguration chartConfiguration)
   at Collabion.Charts.Business.Helpers.DataTableHelper.ApplySplitBy(DataTable sourceTable, GroupByOperation groupBy, ChartConfiguration chartConfiguration)
   at Collabion.Charts.Business.Providers.ListDataProvider.<>c__DisplayClass18.<GetDataFromStorage>b__f()
   at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
   at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
   at Collabion.Charts.Business.Providers.ListDataProvider.GetDataFromStorage(ChartConfiguration ChartConfiguration)
   at Collabion.Charts.Business.Providers.ListDataProvider.GetColumnsToView(ChartConfiguration ChartConfiguration)
   at Collabion.Charts.Business.WebService.GetColumnsToView(String webPartId, String name)
   at Collabion.Charts.WebServicePage.OnInit(EventArgs e)
Inner Stack Trace:    at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
   at System.Data.Common.DateTimeStorage.Set(Int32 record, Object value)
   at System.Data.DataColumn.set_Item(Int32 record, Object value)
Inner Exception: String was not recognized as a valid DateTime.
Additional Information:
Request: http://share.easynet.com/_layouts/CollabionCharts/WebService.aspx

 

It appears the as per my screenshot that the form is being identified as a date / time field. The created date (standard librayr field works but infopath fields do not), please can you help???

 

Thanks

Peter

Edited December 17, 2013 by pmc1982

[Rahul Kumar]

Hi Peter,

 

Could you please post the sample data and at which step you are getting this error?