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...

Environment

EPM Add-in 10.0 for Microsoft

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 for Me (Login required).

Search for additional results

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