AS400 Query
I ran query of all user profiles. I need to change the UPPWCD UPPSOD field from YYMMDD to MMDDYY. You cannot change it in Specify report column formatting. That only handles numeric. Can someone get back to me ASAP? Thanks!
Software/Hardware used:
OS400
Software/Hardware used:
OS400
ASKED:
March 4, 2011 4:02 PM
UPDATED:
March 4, 2011 4:29 PM
Answer Wiki:
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>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
