With a couple of corrections, yes, it did work. PRINT OCONV("16507","D-YMD[2,2,2]":@VM:"MCN")
This returned the value 130311. You were missing the last 2 and the year is 2013, not 2012. This was a good thought, though. Cool!!!! -----Original Message----- From: Charles Stevenson [mailto:stevenson.c...@gmail.com] Sent: Monday, March 11, 2013 10:59 AM To: U2 Users List Cc: Woodward, Bob Subject: Re: [U2] ISO Date Format Bob, I'm curious,on UD6.1 does this work, using 2 conversion codes with a value mark between? : OCONV( "16507", "D-YMD[2,2,]": @VM: "MCN" ) --> "120311" cds On 3/11/2013 12:16 PM, Woodward, Bob wrote: > I guess you need to be on a more current version of UD than 6.1 for > this to work. DYMD[4,2,2] works just fine but everything I've tried > is proving that in this version, anyway, there MUST be a delimiter > between the parts of the date. It does not matter what delimiter as > I've tried space, period, slash, even a comma but for both ICONV and > OCONV adding a quote of any type, null/space/dash/etc, to the numeric > only gives undesired results. > > I have to strip out the delimiter in OCONV results and make sure some > kind of delimiter is there for ICONV to get me back to the internal > date value. > > An interesting note is using the OCONV(IDATE,'D-YMD[2,2,2]') format, > the dash can be replaced with the digits 5 to 9 but using the digits 0 > to 4 result in an output delimited with a space. Would have been > acceptable (and nice) to have been able to get 13003011 but oh well. > I guess I could use 'D5YMD[2,2,2]' to give me the value 13503511 just as well. > > Fun with dates! > > BobW > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles > Stevenson > Sent: Monday, March 11, 2013 8:08 AM > To: U2 Users List > Subject: Re: [U2] ISO Date Format > > By the way, you can also completely eliminate the dash (or slash, > etc.) > delimiters: > > OCONV( "16507" , "DYMD[4'',2'',2]" ) --> "20130311" > ICONV( "20130311", "DYMD[4'',2'',2]" ) --> "16507" > > Notice that ICONV'ing the OCONV'd or OCONV'ing the ICONVd result gets > you bat to where you started. That makes it particularly useful in > dict conversion fields. > > > I learned that on this list, but I do not remember from whom. There > are too many people I've learned from. > > cds > > > On 11 March 2013 13:56, Jeff Schasny <jscha...@gmail.com> wrote: >>> Has anyone come up with an OCONV string that will product an ISO >>> standard date (YYYY-MM-DD)? After a vendor insisted on this last >>> week I ended up creating a subroutine called by an I descriptor but >>> it seems like there should be an easier way. A quick trip through >>> the Universe Basic manual, my old Prime Info-Basic manual, and Pick >>> Basic: A programmer's guide didn't shed any light. > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users