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
