If you just want it reformated on the report.
Create a result field and use SUBSTR
Here are two sample. First as mmddyy second as mm/dd/yy
<pre>
Field Expression
NEWDATE1 SUBSTR(UPPSOD,3,4) ||
SUBSTR(UPPSOD,1,2)
NEWDATE2 SUBSTR(UPPSOD,3,2) || ‘/’ ||
SUBSTR(UPPSOD,5,2) || ‘/’ ||
SUBSTR(UPPSOD,1,2)</pre>
Discuss This Question: 2  Replies
COL_NAME LIKE 'TPAD%'
. This works in WRKQRY on the select records options or if you use SQL for your query.