pmc1982

Date/Time fields from Sharepoint Library

Recommended Posts

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

post-62328-0-40146600-1387293927_thumb.jpg

Edited by pmc1982

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now