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