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
