RE: [?? Probable Spam] RE: [U2]ICONV(VAR,"DB")

2008-05-07 Thread David Murray
http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Wednesday, May 07, 2008 4:16 PM To: u2-users@listserver.u2ug.org Subject: RE: [?? Probable Spam] RE: [U2]ICONV(VAR,"DB") David, It is possibly valid because it

RE: [U2]ICONV(VAR,"DB")

2008-05-07 Thread Jeff Schasny
The compiler does not check the string. See below: >ED BP TTT New record. : I 0001= LLL = ICONV('01/01/01','

RE: [?? Probable Spam] RE: [U2]ICONV(VAR,"DB")

2008-05-07 Thread Irina Lissok
February. Irina Lissok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Murray Sent: Wednesday, May 07, 2008 3:24 PM To: u2-users@listserver.u2ug.org Subject: [?? Probable Spam] RE: [U2]ICONV(VAR,"DB") Irina, I do not think that a ICONV

RE: [U2]ICONV(VAR,"DB")

2008-05-07 Thread David Murray
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Wednesday, May 07, 2008 2:21 PM To: u2-users@listserver.u2ug.org Subject: re:[U2]ICONV(VAR,"DB") Hey all, We are using ICONV(VAR,'DB') and it works perfectly except one case when the da

RE: [U2]ICONV(VAR,"DB")

2008-05-07 Thread Israel, John R.
ration 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Wednesday, May 07, 2008 2:21 PM To: u2-users@listserver.u2ug.org Subject: re:[U2]ICONV(VAR,"DB") Hey all, We are using IC

re:[U2]ICONV(VAR,"DB")

2008-05-07 Thread Irina Lissok
Hey all, We are using ICONV(VAR,'DB') and it works perfectly except one case when the date is the last day of February any year. For instance for VAR=31-MAR-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR=14335 For VAR=28-FEB-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' In case VAR=29-FEB-