Re: [U2] Internal date conversion

2005-07-22 Thread Anthony W. Youngman
In message [EMAIL PROTECTED], Gordon J Glorfield [EMAIL PROTECTED] writes FYI This does work in UV. Which is odd to me. I had always thought that in an ICONV anything following the D was ignored. I wonder when this changed? It's been in PI as long as I can remember ... I've learned

Re: [U2] Internal date conversion

2005-07-15 Thread FFT2001
In a message dated 7/14/05 12:29:17 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: INT.DATE = ICONV(OCONV(external.date,'MCN'),'D') The OCONV strips everything non-numeric leaving 20050714 which will ICONV to the internal date. Using this method, how would the system be able to

Re: [U2] Internal date conversion

2005-07-15 Thread FFT2001
In a message dated 7/14/05 11:17:53 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: I have found that a general date conversion is pretty flexible in UV (not sure about Unidata yet) Try: I.DATE = ICONV(EXTERN.DATE,D) I might be wrong but I do not believe the D Iconv is coded to

Re: [U2] Internal date conversion

2005-07-15 Thread Jerry Banker
Smartass. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, July 15, 2005 4:38 PM Subject: Re: [U2] Internal date conversion In a message dated 7/14/05 12:29:17 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: INT.DATE = ICONV(OCONV

Re: [U2] Internal date conversion

2005-07-15 Thread Josh Volosov (3)
Hi, I will be at a customer's office from July 18th through July 21st. I will return to the office on July 22nd. I will limited access to e-mail or voice mail. If a you need an immediate response to your e-mail please e-mail [EMAIL PROTECTED] or you can call Frank at extension 467. Thanks and

RE: [U2] Internal date conversion

2005-07-14 Thread Larry Hiscock
:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] Internal date conversion I want to convert a date in following format to Universe internal format. Can anyone please provide me the specific format command? -MM-DD e.g. 2005-07-14 is the input format. I want to store it in equivalent Universe

RE: [U2] Internal date conversion

2005-07-14 Thread Richard Taylor
PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Pankaj Gupta04 Sent: Thursday, July 14, 2005 12:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Internal date conversion I want to convert a date in following format to Universe internal format. Can anyone please provide me

RE: [U2] Internal date conversion

2005-07-14 Thread Gordon J Glorfield
FYI This does work in UV. Which is odd to me. I had always thought that in an ICONV anything following the D was ignored. I wonder when this changed? I've learned something new so it's not a completely wasted day. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth

RE: [U2] Internal date conversion

2005-07-14 Thread Glenn Herbert
Group 50 Washington Street Westboro, MA 01581 508-599-7281 direct Gordon J Glorfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/14/2005 02:41 PM Please respond to u2-users To u2-users@listserver.u2ug.org cc Subject RE: [U2] Internal date conversion FYI This does work in UV. Which

Re: [U2] Internal date conversion

2005-07-14 Thread Roger Glenfield
About the same time as D2E started iconverting DAY/MON/YEAR? I think I preferred the Ultimate method of setting a system wide flag and letting D2/ be D2/ for the locals. Or even better, MMDDYY instead of slashing/dashing. Of course, some preferred not having to enter years, entering 7/13