<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Incorrect sorting using dynamic column</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=469371507-03032006><FONT face=Arial
color=#0000ff size=2>Most likely it is interpreted as a character field (at
least the sort is correct according to that interpretation). Hopefully this is a
field where you fill the value (not filled automatically). To get correct sort
order, use ISO date format yyyy-mm-dd instead of just a plain write statement
when writing the date to the field.</FONT></SPAN></DIV>
<DIV align=left><FONT face=Arial size=2>-- </FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Kjetil Kilhavn, Statoil ØFT KTJ
BAS DEV SAP</FONT></DIV>
<DIV align=left>
<DIV align=left><FONT face=Arial size=2>
<DIV align=left>
<DIV align=left>
<DIV align=left><FONT face=Arial size=2></FONT></FONT><FONT
size=1></DIV></DIV></DIV></DIV></FONT><FONT face=Arial color=#0000ff
size=2></FONT></DIV><FONT face=Arial size=2></FONT><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> sap-wug-bounces@mit.edu
[mailto:sap-wug-bounces@mit.edu] <B>On Behalf Of </B>Awosika,
Lola<BR><B>Sent:</B> 3. mars 2006 08:00<BR><B>To:</B> SAP Workflow Users'
Group<BR><B>Subject:</B> Incorrect sorting using dynamic
column<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><FONT face=Arial size=2>Hi,</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>I was wondering if anyone has come across
this error and resolve</FONT></SPAN><SPAN lang=fi><FONT face=Arial
size=2>d</FONT></SPAN><SPAN lang=en-us><FONT face=Arial size=2>
it</FONT></SPAN><SPAN lang=fi><FONT face=Arial size=2>, basis is
640</FONT></SPAN><SPAN lang=en-us><FONT face=Arial size=2>:</FONT></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial size=2>A dynamic column is used to
display invoice due date in the workflow inbox. When agents try to sort the
inbox using this dynamic column, the sort order is incorrect. It seems the
sorting is done using only the fist two fields of the date:</FONT></SPAN></P>
<P><SPAN lang=en-us><FONT face=Arial color=#000000 size=2><IMG
alt="Picture (Metafile)" src="No%20AttachName"></FONT></SPAN> </P><BR><BR>
<P><SPAN lang=en-gb><FONT face=Arial>Regards,</FONT></SPAN> <BR><SPAN
lang=en-gb><FONT face=Arial>Lola Awosika.</FONT></SPAN>
</P></BLOCKQUOTE><p></p><p><font size=1>-------------------------------------------------------------------<br>The information contained in this message may be CONFIDENTIAL and is<br>intended for the addressee only. Any unauthorised use, dissemination of the<br>information or copying of this message is prohibited. If you are not the<br>addressee, please notify the sender immediately by return e-mail and delete<br>this message.<br>Thank you.</font size></BODY></HTML>