Sounds like a number of folks have been burned along these lines. At least it isn't just me.
Thanks for the input. Everyone have a great weekend! John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Nancy Fisher Sent: Friday, January 20, 2012 1:22 PM To: 'U2 Users List' Subject: Re: [U2] Date Problem I also quit using @DATE and changed to DATE() as @DATE was not 100% reliable. Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website www.peninsulatruck.com [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Israel, John R. Sent: Friday, January 20, 2012 10:20 AM To: 'U2 Users List' Subject: Re: [U2] Date Problem If it were just a few programs, I would not be too concerned. However, it is an INCLUDE that is included in hundreds of programs, so the impact could be huge (even if the impact is to be correct). However, I have "pulled the trigger" and replaced the @DATE to DATE() in the INCLUDE. Some programs will need to be re-compiled, others will take the effect when next re-compiled. This is NOT the solution I wanted, but appears to be the solution I must take... Bummer John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Hester Sent: Friday, January 20, 2012 1:14 PM To: U2 Users List Subject: Re: [U2] Date Problem I ran into an issue with @DATE many years ago, but this was on UV and probably around version 8.3 or 9.5.1. The problem I ran into was @DATE failed in programs run as phantoms but worked fine if the program was run via a terminal. DATE() always worked correctly. We had migrated from Ultimate not too many years before, and all of our legacy code used DATE(), so it wasn't a big deal for me to replace the few instances of @DATE with DATE(). I haven't used @DATE since. -John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Israel, John R. Sent: Friday, January 20, 2012 9:36 AM To: 'U2 Users List' Cc: Conway, Bruce; Majors,Larry Subject: [U2] Date Problem I have an INCLUDE that I use in ALL programs I touch. It simply does a bunch of assigning of variables so that I can use them as needed. One of these assignments is: TODAY = @DATE I have 1 program in 1 account that is consistently returning: 16066 (which is 12/26/11). This program is initiated via a Redback call but so are many many others. In the pgm that is failing, immediately after my INCLUDE, I just added code to write the following to disk: TODAY DATE() @DATE Both TODAY and @DATE ALWAYS return 16066 for this 1 program, but no others. The same program is working correctly in other accounts, and the value of TODAY is correct in EVERY other program I have ever used. Does anyone have a clue? I could replace @DATE with DATE() in my INCLUDE, but to do my due diligence, I should recompile EVERY program that uses the INCLUDE (and that is NOT going to happen). John John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 [email protected] This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
