Frank Swarbrick on IBM Mainframe Discussion List <[email protected]> wrote on 09/22/2010 10:23:28 AM: > Does DFSORT conversion from a "day of the year" format to an actual > date format? Specifically, we have a file that stores dates as > packed-decimal 5 characters (+ sign), ie YYDDDs where YY is the two > digit year, DDD is the day of the year and s is the sign nibble. I > am able to use "p,m,Y2U,EDIT=(TTTT/TTT)" to convert to display > "YYYY/DDD" format but what I really want is "YYYY/MM/DD" or "DD/MM/ > YYYY" format.
Frank, You can use DFSORT's date conversion functions to do that: p,3,Y2U,TOGREG=(Y4T(/)) will give you a 'yyyy/mm/dd' date. 1,3,Y2U,DT=(DM4/) will give you a 'dd/mm/yyyy' date. For complete details on DFSORT's date conversion functions, see: http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000174 Frank Yaeger - DFSORT Development Team (IBM) - [email protected] Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
