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:[email protected]]
Sent: Tuesday, April 24, 2012 07:55 PM
To: 'U2 Users List'<[email protected]>
Subject: Re: [U2] YYMMDD easy way?
On Unidata try: OCONV(TODAY,'DYMD')
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wjhonson
Sent: Tuesday, April 24, 2012 4:52 PM
To: [email protected]
Subject: [U2] YYMMDD easy way?
YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')
easier way to do this? _______________________________________________
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
