SAP Knowledge Base Article - Preview

2653853 - EPM Add-in: "String was not recognized as a valid Date Time"

Symptom

When you are trying to sort the file by clicking the Modifed column, error "String was not recognized as a valid Date Time" occurs.

sort invalid date.jpg

invalid date error.jpg

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.FormatException: String was not recognized as a valid DateTime.
at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at FPMXLClient.UILayer.Classes.DateTimeComparer`1.Compare(T x, T y) in D:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\UILayer\UI\Classes\ListView\UIListViewDecorator.cs:line 541
at System.Linq.EnumerableSorter`2.CompareKeys(Int32 index1, Int32 index2)
at System.Linq.EnumerableSorter`1.QuickSort(Int32[] map, Int32 left, Int32 right)
at System.Linq.EnumerableSorter`1.Sort(TElement[] elements, Int32 count)
at System.Linq.OrderedEnumerable`1.<GetEnumerator>d__1.MoveNext()
at System.Linq.Enumerable.Count[TSource](IEnumerable`1 source)
at FPMXLClient.UILayer.Classes.UIListViewDecorator`1.SortWithColumn() in D:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\UILayer\UI\Classes\ListView\UIListViewDecorator.cs:line 322
at FPMXLClient.UILayer.Classes.UIListViewDecorator`1.Sort(Int32 column) in D:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\UILayer\UI\Classes\ListView\UIListViewDecorator.cs:line 356
at FPMXLClient.UILayer.Classes.UIListViewDecorator`1.m_listView_ColumnClick(Object sender, ColumnClickEventArgs e) in D:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\UILayer\UI\Classes\ListView\UIListViewDecorator.cs:line 183
at System.Windows.Forms.ListView.OnColumnClick(ColumnClickEventArgs e)
at System.Windows.Forms.ListView.WmNotify(Message& m)
at System.Windows.Forms.ListView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


Read more...

Keywords

KBA , EPM-XLS , EPM Excel Client , EPM-BPC-NW , NetWeaver Version , EPM-BPC-MS , Microsoft Version , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.