Better might be: ICONV("2005-07-14","D-YMD[4,2,2]")
_________________________________________________________
"I reject your reality and substitute my own" - Adam Savage
Glenn M. Herbert - Connectivity Development Engineer
Information Integration Solutions, IBM Software Group
50 Washington Street Westboro, MA 01581
508-599-7281 direct
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/14/2005 12:56 PM
Please respond to
u2-users
To
[email protected]
cc
Subject
Re: [U2] Internal date conversion
In a message dated 7/14/2005 9:50:12 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:
> Can anyone please provide me the specific format command?
> YYYY-MM-DD e.g. 2005-07-14 is the input format.
> I want to store it in equivalent Universe format i.e. 13710.
Wouldn't you need to do something like this?
T.DATE = "2005-07-14"
NEW.DATE = ICONV(T.DATE,"G1-2"):"-":ICONV(T.DATE,"G0-1")
INTERNAL.DATE = ICONV(NEW.DATE,"D")
Will Johnson
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
