[U2] Coversion Code for Date
All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
OCONV(NIDATA49,TAJ,DY4MD-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 3:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Coversion Code for Date All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ 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
Re: [U2] Coversion Code for Date
Consider something like... Today = date() This.Date = oconv(Today, 'DD') This.Month = oconv(Today, 'DM') This.Year = oconv(Today, 'DY') This.Long = This.Year : '-' : This.Month : '-' : This.Date --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 3:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Coversion Code for Date All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ 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
Re: [U2] Coversion Code for Date
Looks like D4-YMD works. Thanks all! Sincerely, Nathan Dube Network Administrator Jerry Pate Turf Irrigation -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 2:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Coversion Code for Date All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ 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
Re: [U2] Coversion Code for Date
Kevin King from Precision Solutions hooked me up btw. Sincerely, Nathan Dube Network Administrator Jerry Pate Turf Irrigation -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 3:06 PM To: U2 Users List Subject: Re: [U2] Coversion Code for Date Looks like D4-YMD works. Thanks all! Sincerely, Nathan Dube Network Administrator Jerry Pate Turf Irrigation -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 2:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Coversion Code for Date All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ 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
Re: [U2] Coversion Code for Date
FYI - DY4MD- and D4-YMD will output -M-DD for single digit months. D4-YMD[4,2,2] will properly output -MM-DD. rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
Forgot to mention on Windows, Universe 10.3.7, Pick flavor: On Fri, Jun 3, 2011 at 5:04 PM, Rex Gozar rgo...@gmail.com wrote: FYI - DY4MD- and D4-YMD will output -M-DD for single digit months. D4-YMD[4,2,2] will properly output -MM-DD. rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
Worked fine for me..Maybe that's a flavor issue. I'm running in Information Flavor. 0001= PRINT OCONV(ICONV(01/01/2010,D),DY4MD-) 0002= STOP 0003= END RUN LIB TEST 2010-01-01 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: Friday, June 03, 2011 5:05 PM To: U2 Users List Subject: Re: [U2] Coversion Code for Date FYI - DY4MD- and D4-YMD will output -M-DD for single digit months. D4-YMD[4,2,2] will properly output -MM-DD. rex ___ 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
Re: [U2] Coversion Code for Date
I think the difference might be Unidata vs. Universe. George, you're on UV, right? Nathan is UD. I'd be interested to know, does D4-YMD work on UV? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
Another variation... OCONV(THE.DATE, 'DYMD-[4,2,2]') - Original Message - From: Bill Brutzman [mailto:bi...@hkmetalcraft.com] Sent: Friday, June 03, 2011 03:52 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Coversion Code for Date Consider something like... Today = date() This.Date = oconv(Today, 'DD') This.Month = oconv(Today, 'DM') This.Year = oconv(Today, 'DY') This.Long = This.Year : '-' : This.Month : '-' : This.Date --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 3:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Coversion Code for Date All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ 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 CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
UV on HP-UX -- PI flavor : 0001: TODAY = DATE() : 0002: PRINT OCONV(TODAY,'D4-YMD') : 0003: END Bottom at line 3. : Q :RUN SRC RFPD4 2011-06-03 Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. precisonl...@gmail.com 6/3/2011 4:27 PM I think the difference might be Unidata vs. Universe. George, you're on UV, right? Nathan is UD. I'd be interested to know, does D4-YMD work on UV? ___ 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
Re: [U2] Coversion Code for Date
precisonl...@gmail.com wrote: I think the difference might be Unidata vs. Universe. George, you're on UV, right? Nathan is UD. I'd be interested to know, does D4-YMD work on UV? ___ 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
