Re: [U2] YYMMDD easy way?
On 2 - neither java or c# (or vb.net) are functional (f# is) - and the whole closure/lambda thing - should we introduce that to databasic ?? ;) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 26 April 2012 17:37 To: U2 Users List Subject: Re: [U2] YYMMDD easy way? 1. SLoC = Source Lines of Code. Complaining about code bloat reminds me of the king in the Amadeus movie complaining about... too many notes. 2. Just like when .Net came out and many VB programmers moaned about the horrors of object-oriented programming... there is some fresh angst forthcoming with the new closure functionality in Java 8. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, April 26, 2012 10:57 AM Subject: Re: [U2] YYMMDD easy way? Hi Bill, You'll still need to make sure the month and day are zero padded to get YYMMDD. Could you explain this: /Counting SLoCs is meaningless. Also... functional programming is out there now... multiple threads... running on multiple cores. I am starting to treat variables as though they were carbohydrates. / I'm not sure what you're trying to say (brain in molasses mode today). Charlie ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1424 / Virus Database: 2411/4960 - Release Date: 04/26/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Fleshing it out makes it easier to read and maintain. thisYear = oconv(today, 'DY2') thisMonth = oconv(today, 'DM') thisDate = oconv(today, 'DD') yyMMdd = thisYear : thisMonth : thisDate Counting SLoCs is meaningless. Also... functional programming is out there now... multiple threads... running on multiple cores. I am starting to treat variables as though they were carbohydrates. --Bill -Original Message- From: u2-users-bounces On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 7:52 PM YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Hi Bill, You'll still need to make sure the month and day are zero padded to get YYMMDD. Could you explain this: /Counting SLoCs is meaningless. Also... functional programming is out there now... multiple threads... running on multiple cores. I am starting to treat variables as though they were carbohydrates. / I'm not sure what you're trying to say (brain in molasses mode today). Charlie On 04-26-2012 9:34 AM, Bill Brutzman wrote: Fleshing it out makes it easier to read and maintain. thisYear = oconv(today, 'DY2') thisMonth = oconv(today, 'DM') thisDate = oconv(today, 'DD') yyMMdd = thisYear : thisMonth : thisDate Counting SLoCs is meaningless. Also... functional programming is out there now... multiple threads... running on multiple cores. I am starting to treat variables as though they were carbohydrates. --Bill -Original Message- From: u2-users-bounces On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 7:52 PM YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
1. SLoC = Source Lines of Code. Complaining about code bloat reminds me of the king in the Amadeus movie complaining about... too many notes. 2. Just like when .Net came out and many VB programmers moaned about the horrors of object-oriented programming... there is some fresh angst forthcoming with the new closure functionality in Java 8. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, April 26, 2012 10:57 AM Subject: Re: [U2] YYMMDD easy way? Hi Bill, You'll still need to make sure the month and day are zero padded to get YYMMDD. Could you explain this: /Counting SLoCs is meaningless. Also... functional programming is out there now... multiple threads... running on multiple cores. I am starting to treat variables as though they were carbohydrates. / I'm not sure what you're trying to say (brain in molasses mode today). Charlie ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
ICONV works, too! ICONV( 120425, DYMD[2'',2''] ) -- 16187 OCONV( 16187, DYMD[2'',2''] ) -- 120425 If you ICONV an invalid date, e.g. April 34th: ICONV( 120434, DYMD[2'',2''] ) -- and STATUS()=1 I believe mathemeticians would call those inverse transformations. I was going to say reflexive but that would mean the very same transformation applied 2x gets back to the original place. cds On 4/24/2012 6:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Yes. Many people don't know you can stack conversion codes, separated by value marks (like in Pick dict 8 correlatives). But in this instance the DYMD[2'',2'',2] conversion discussed elsewhere in the thread has the advantage of being able to be used in ICONV, too, to get from YYMMDD to an internal date: ICONV( 120425, DYMD[2'',2''] ) -- 16187 On 4/24/2012 6:57 PM, Martin Braid wrote: OCONV(DATE(),D2YMD:@VM:MCN) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 25 April 2012 00:52 To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 2eKQFaw1sOoTA9gaOpFHJJo+VEWAxlvp7UeaPLWGci2!g== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users . ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
I find this however to be a rather unfamiliar area. I like the idea of using the CONVERT because I have confidence that at least one other person in my group would understand what that meant. This use of formatting to limit the size of output in this way ( below) is pretty obscure. -Original Message- From: Charles Stevenson stevenson.c...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 5:42 am Subject: Re: [U2] YYMMDD easy way? Yes. Many people don't know you can stack conversion codes, separated by value marks (like in Pick dict 8 correlatives). But in this instance the DYMD[2'',2'',2] conversion discussed elsewhere in the thread has the advantage of being able to be used in ICONV, too, to get from YYMMDD to an internal date: ICONV( 120425, DYMD[2'',2''] ) -- 16187 On 4/24/2012 6:57 PM, Martin Braid wrote: OCONV(DATE(),D2YMD:@VM:MCN) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 25 April 2012 00:52 To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 2eKQFaw1sOoTA9gaOpFHJJo+VEWAxlvp7UeaPLWGci2!g== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users . ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
OBTW, on UniVerse both concatenations: D2YMD:@VM:MCN are done at compile-time because all elements are constant strings. (@VM isn't really a variable, more like an EQUate.) So if you stick Martin's construct inside a loop, there no added burden. On 4/24/2012 6:57 PM, Martin Braid wrote: OCONV(DATE(),D2YMD:@VM:MCN) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
me: Win 2003 Perry? 10.2? 10.3? Redhat? I'd sure like to know what makes the difference. I'd hate to get bit - again! - in a migration or upgrade. The worst fall-out I ever had in an upgrade was when they changed an obscure FMT code without telling anyone. On 4/25/2012 9:07 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
RHEL5 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Wednesday, April 25, 2012 8:30 AM To: U2 Users List Subject: Re: [U2] YYMMDD easy way? me: Win 2003 Perry? 10.2? 10.3? Redhat? I'd sure like to know what makes the difference. I'd hate to get bit - again! - in a migration or upgrade. The worst fall-out I ever had in an upgrade was when they changed an obscure FMT code without telling anyone. On 4/25/2012 9:07 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2's. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD['' , '']) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Hi Chuck, I've never seen this to fail on any implementation or flavor: OCONV(TODAY,'DY2')'R%2': OCONV(TODAY,'DM')'R%2': OCONV(TODAY,'DD')'R%2' If anyone has, please let me know and I'll rethink. The code assumes (yeah, I know) that TODAY is in ICONV form. I've always used D2Y (I don't remember why) but it's interesting to note that DY2 works as well. Charlie On 04-25-2012 9:30 AM, Charles Stevenson wrote: me: Win 2003 Perry? 10.2? 10.3? Redhat? I'd sure like to know what makes the difference. I'd hate to get bit - again! - in a migration or upgrade. The worst fall-out I ever had in an upgrade was when they changed an obscure FMT code without telling anyone. On 4/25/2012 9:07 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Even the best code for converting an internal date to an external one is a tad complicated. I would take all reasonable steps to avoid doing it an extra two times per date. -Rick On Apr 25, 2012, at 7:43 AM, Charlie Noah cwn...@comcast.net wrote: Hi Chuck, I've never seen this to fail on any implementation or flavor: OCONV(TODAY,'DY2')'R%2': OCONV(TODAY,'DM')'R%2': OCONV(TODAY,'DD')'R%2' If anyone has, please let me know and I'll rethink. The code assumes (yeah, I know) that TODAY is in ICONV form. I've always used D2Y (I don't remember why) but it's interesting to note that DY2 works as well. Charlie On 04-25-2012 9:30 AM, Charles Stevenson wrote: me: Win 2003 Perry? 10.2? 10.3? Redhat? I'd sure like to know what makes the difference. I'd hate to get bit - again! - in a migration or upgrade. The worst fall-out I ever had in an upgrade was when they changed an obscure FMT code without telling anyone. On 4/25/2012 9:07 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Actually the below is a trifle odd What this seems to be saying is, the M returns 4 or perhaps 4 (space 4) by itself, since the '' evidently removes spaces or something But the M with a 2'' returns a ZERO 4 (04) From where the heck does the zero come? I could see it as logical is the M returned a 04 normally but it seems to not. Unless of course the '' means also supress leading zeroes On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Mine is on HP-UX B.11.31. Richard On Wed, Apr 25, 2012 at 8:07 AM, Rick Nuckolls r...@lynden.com wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard Perry describe. OCONV( 16187, DYMD['',''] ) = 2012425 OCONV( 16187, DYMD[2'',2''] ) = 120425 Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List'u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] YYMMDD easy way?
YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
OCONV(DATE(),D2YMD:@VM:MCN) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 25 April 2012 00:52 To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== 2eKQFaw1sOoTA9gaOpFHJJo+VEWAxlvp7UeaPLWGci2!g== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
On Universe you get a 4 digit year, and spaces between the pieces -Original Message- From: Lunt, Bruce bl...@shaklee.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, Apr 24, 2012 4:56 pm Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Tuesday, April 24, 2012 4:52 PM o: u2-users@listserver.u2ug.org ubject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Wow... what is this doing? I don't even recognize this type of code. A format mask of some kind? -Original Message- From: Perry Taylor perry.tay...@zirmed.com To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Sent: Tue, Apr 24, 2012 4:58 pm Subject: Re: [U2] YYMMDD easy way? OCONV(TODAY, 'DYMD[4,2,2]') Original Message - rom: Lunt, Bruce [mailto:bl...@shaklee.com] ent: Tuesday, April 24, 2012 07:55 PM o: 'U2 Users List' u2-users@listserver.u2ug.org ubject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson ent: Tuesday, April 24, 2012 4:52 PM o: u2-users@listserver.u2ug.org ubject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any ttachments, is for the sole use of the intended recipient(s) nd may contain confidential and privileged information. Any nauthorized review, use, disclosure or distribution is rohibited. ZirMed, Inc. has strict policies regarding the ontent of e-mail communications, specifically Protected Health nformation, any communications containing such material will e returned to the originating party with such advisement oted. If you are not the intended recipient, please contact he sender by reply e-mail and destroy all copies of the riginal message. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
I use: YYMMDD = CONVERT( , , OCONV(TODAY, DYMD2)) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckolls r...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckolls r...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
On Jbase with different values to TODAY: OCONV(TODAY, 'D2-') = 04-24-12 OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')= 12424 no OCONV(DATE(),D2YMD:@VM:MCN) = 12 no OCONV(TODAY,'DYMD') = 2012 no OCONV(TODAY, 'DYMD[4,2,2]') = 2012 no CONVERT( , , OCONV(TODAY, DYMD2)) = 2012 no OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' = 120424 yes OCONV(TODAY, 'D2-') = 01-01-12 OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')= 1211 no OCONV(DATE(),D2YMD:@VM:MCN) = 12 no OCONV(TODAY,'DYMD') = 2012 no OCONV(TODAY, 'DYMD[4,2,2]') = 2012 no CONVERT( , , OCONV(TODAY, DYMD2)) = 2012 no OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' = 120101 yes OCONV(TODAY, 'D2-') = 12-12-12 OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')= 121212 yes OCONV(DATE(),D2YMD:@VM:MCN) = 12 no OCONV(TODAY,'DYMD') = 2012 no OCONV(TODAY, 'DYMD[4,2,2]') = 2012 no CONVERT( , , OCONV(TODAY, DYMD2)) = 2012 no OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' = 121212 yes I don't know about other implementation, but I think OCONV(TODAY,'DY2')'R%2':OCONV(TODAY,'DM')'R%2':OCONV(TODAY,'DD')'R%2' would work anywhere. Charlie Noah Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds Info, Forum: http://www.TinyBearMarketing.com Store:http://Stores.TinyBearMarketing.com Toll Free: 1-855-TinyBear (855-846-9232) On 04-24-2012 7:01 PM, David A. Green wrote: I use: YYMMDD = CONVERT( , , OCONV(TODAY, DYMD2)) David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckolls r...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckolls r...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] YYMMDD easy way?
That was my thought, but the flavor does not seem to affect it on my version. -Rick On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote: Or maybe it's my Pick flavor. Richard Lewis On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckolls r...@lynden.com wrote: Hmmm, That must be a change at UV 11. 10.2.x still produces 2 digit months and days without the extra 2’s. -Rick On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote: On UV 11.1.3 this leaves single-digit months as a single digit. OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly. The brackets allow format modifiers to the parameters that follow the D conversion code, in this case, 'YMD'. The 2's specifiy how many characters to display, and the empty quotes specify the 'text' with which to separate the elements. There's about 80 lines that describe it when you do HELP CONV D at TCL. Richard Lewis On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckolls r...@lynden.com wrote: Or, a bit more simply: OCONV(TODAY, D2YMD[‘’ , ’’]”) On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote: OCONV(TODAY, 'DYMD[4,2,2]') - Original Message - From: Lunt, Bruce [mailto:bl...@shaklee.com] Sent: Tuesday, April 24, 2012 07:55 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] YYMMDD easy way? On Unidata try: OCONV(TODAY,'DYMD') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 24, 2012 4:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] YYMMDD easy way? YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD') easier way to do this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users