Re: [U2] ISO Date Format

2013-03-11 Thread John Hatherill
D-YMD John W Hatherill Programmer / Analyst Harrington Industrial Plastics -Original Message- From: Jeff Schasny [mailto:jscha...@gmail.com] Sent: Monday, March 11, 2013 6:57 AM To: U2-Users@listserver.u2ug.org Subject: [U2] ISO Date Format Has anyone come up with an OCONV string that

Re: [U2] ISO Date Format

2013-03-11 Thread Wjhonson
: Re: [U2] ISO Date Format What? It's 2013 already? ! ! ! ? ! Why didn't someone tell me? I set my clock ahead yesterday and everything. On 3/11/2013 1:10 PM, Woodward, Bob wrote: > With a couple of corrections, yes, it did work. > > PRINT OCONV("16507","

Re: [U2] ISO Date Format

2013-03-11 Thread Anthonys Lists
On 11/03/2013 17:16, Woodward, Bob wrote: 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 13

Re: [U2] ISO Date Format

2013-03-11 Thread Charles Stevenson
his 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 Subj

Re: [U2] ISO Date Format

2013-03-11 Thread Woodward, Bob
e- 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", &

Re: [U2] ISO Date Format

2013-03-11 Thread Charles Stevenson
,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

Re: [U2] ISO Date Format

2013-03-11 Thread Woodward, Bob
s 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 Us

Re: [U2] ISO Date Format

2013-03-11 Thread David A. Green
Subject: [U2] ISO Date Format Has anyone come up with an OCONV string that will product an ISO standard date (-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

Re: [U2] ISO Date Format

2013-03-11 Thread Tony Gravagno
It's things like this that make me wish more MV platforms had user-defined processor codes. U2 excels in the versatility here. I can't use wonderful codes like this because most of my code needs to work across platforms. Wah. :'( T > From: Charles Stevenson > OCONV( "16507" , "DYMD[4'',2'',2

Re: [U2] ISO Date Format

2013-03-11 Thread Jeff Schasny
I knew it had to be possible. Thanks Brian Leach wrote: D-YMD[4,2,2] -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: 11 March 2013 13:57 To: U2-Users@listserver.u2ug.org Subject: [U2] ISO Date

Re: [U2] ISO Date Format

2013-03-11 Thread Charles Stevenson
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.

Re: [U2] ISO Date Format

2013-03-11 Thread Robert Harris
Blasted Google Mail, sent a blank reply in error.. Beaten to the punch by Brian, was going to post; OCONV(INPDATE, "D4-YMD[4,2,2]") Rob Harris Senior Software Engineer Group IT Engineering, the OMEN Tel : 01604 502666 Please consider your environmental responsibilities before printing this emai

Re: [U2] ISO Date Format

2013-03-11 Thread Robert Harris
Rob Harris Senior Software Engineer Group IT Engineering, the OMEN Tel : 01604 502666 Please consider your environmental responsibilities before printing this email On 11 March 2013 13:56, Jeff Schasny wrote: > Has anyone come up with an OCONV string that will product an ISO standard > date (Y

Re: [U2] ISO Date Format

2013-03-11 Thread Brian Leach
D-YMD[4,2,2] -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: 11 March 2013 13:57 To: U2-Users@listserver.u2ug.org Subject: [U2] ISO Date Format Has anyone come up with an OCONV string that will

[U2] ISO Date Format

2013-03-11 Thread Jeff Schasny
Has anyone come up with an OCONV string that will product an ISO standard date (-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 o