Frank, Just got the PTF applied (had to wait for an IPL for it to become effective) and it's exactly what I wanted. Thanks! Ended up using "67,3,Y2U,TOGREG=(Y4W(/))" to give me C'mm/dd/ccyy' format. Great! Nice to be able to use something other than COBOL for simple file extracts.
Frank -- Frank Swarbrick Applications Architect - Mainframe Applications Development FirstBank Data Corporation - Lakewood, CO USA P: 303-235-1403 On 9/22/2010 at 11:38 AM, in message <of8694fa78.4aab9952-on882577a6.00606bb2-882577a6.0060e...@us.ibm.com>, Frank Yaeger <[email protected]> wrote: > 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 >>> The information contained in this electronic communication and any document attached hereto or transmitted herewith is confidential and intended for the exclusive use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any examination, use, dissemination, distribution or copying of this communication or any part thereof is strictly prohibited. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy this communication. Thank you. ---------------------------------------------------------------------- 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
