<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>Hi,</div>
<div> </div>
<div>to make the date's sortable, I usually use a secondary character-based field based on CHAR10, where I compose the date format manually to YYYY-MM-DD This way it's sortable and there're no problems with the dynamic columns.</div>
<div> </div>
<div>florin</div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b> Donnerstag, 03. April 2014 um 18:01 Uhr<br/>
<b>Von:</b> "Robert van den Berg" <wug@bergtop-ict.nl><br/>
<b>An:</b> "SAP Workflow Users' Group" <sap-wug@mit.edu><br/>
<b>Betreff:</b> Re: Dynamic columns date format</div>
<div name="quoted-content">All,
<div> </div>
<div>the note solved the issue. Dynamic column that refers to a container element of type DATS is now displayed in dotted format DD.MM.YYY and decimal is shown with a comma instead of a point.</div>
<div> </div>
<div>New issue is that I can not filter on it, but that is the next step... ;-)</div>
<div> </div>
<div>Regards,</div>
<div>Robert<br/>
<p>Op 3 april 2014, schreef Robert van den Berg <wug@bergtop-ict.nl>:</p>
<blockquote>
<div class="oneComWebmail-html oneComWebmail-mail">
<div class="oneComWebmail-body">Well, I found note <span style="background-color: rgb(255,255,255);">1709141. My basis guys are implementing the note, hopefully it wil solve the issue.</span>
<div> </div>
<div>
<p class="oneComWebmail-urTxtH1" style="font-family: Arial , Helvetica , sans-serif;font-size: medium;font-weight: bold;background-color: rgb(255,255,255);white-space: nowrap;"><font color="#04357B">Symptom</font></p>
<div class="oneComWebmail-longtext oneComWebmail-MonoSpace" id="oneComWebmail-MonoSpace" style="font-family: "Lucida Console" , Monaco , "Courier new" , monospace;font-size: 12.0px;background-color: rgb(255,255,255);">
<p>You use the SAP Business Workplace. The dynamic columns show date fields or time fields without output format.</p>
<div> </div>
<div> </div>
</div>
<p>Op 2 april 2014, schreef Kjetil Kilhavn <list.sap-wug@vettug.no>:</p>
<blockquote>
<div class="oneComWebmail-oneComWebmail-mail">
<div class="oneComWebmail-oneComWebmail-body">Tirsdag 1. april 2014 12.07.33 skrev Robert van den Berg:
<blockquote>Hi all,<br/>
<br/>
I have created a dynamic column for a containerelement with data-element<br/>
SYST-DATUM. I pass a value of type DATS to this container element.<br/>
<br/>
But in my inbox, the date value is shown as 20140401 instead of 01.04.2014.<br/>
But the standard column's like creation date work item are shown in the<br/>
dotted format.<br/>
<br/>
What is going wrong here?</blockquote>
<br/>
Nothing is going wrong, it just is not working like you want it to ;-)<br/>
The dynamic columns are text fields, so you must WRITE the date to that field.<br/>
<br/>
<blockquote>Also, I have this with a DEC field....<br/>
<br/>
Regards,<br/>
Robert</blockquote>
--<br/>
Kjetil Kilhavn / Vettug AS (<a href="http://www.vettug.no" target="_blank">http://www.vettug.no</a>)<br/>
_______________________________________________<br/>
SAP-WUG mailing list<br/>
SAP-WUG@mit.edu<br/>
<a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a></div>
</div>
</blockquote>
</div>
</div>
</div>
<div class="oneComWebmail-mail">
<div class="oneComWebmail-body">_______________________________________________<br/>
SAP-WUG mailing list<br/>
SAP-WUG@mit.edu<br/>
<a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a></div>
</div>
</blockquote>
</div>
_______________________________________________ SAP-WUG mailing list SAP-WUG@mit.edu <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a></div>
</div>
</div>
</div></div></body></html>