Marco, this is absolutely brilliant. And I reserve the use of the word "brilliant", for code that truly transcends normal space-time I'm not certain that the use of "DD" is vendor independent, but it could be made so, by merely using OCONV(TODAY, 'DD') instead
-----Original Message----- From: Marco Antonio Rojas Castro <[email protected]> To: u2-users <[email protected]> Sent: Mon, Dec 5, 2011 12:49 pm Subject: Re: [U2] End of Month date routine ODAY = DATE() OM = TODAY - TODAY"DD" + 32 OM = EOM - EOM"DD" > To: [email protected] From: [email protected] Date: Mon, 5 Dec 2011 15:16:02 -0500 Subject: Re: [U2] End of Month date routine Doesn't work on my system Anthony. The This month o gives the month and year ok but the attempt to iconv that sets it to zero, it doesn't pad the "01" into it r something so i just get 31 at that point. I think you were expecting that it would take "12 2011" and make it into "12 1 2011" or whatever but it's not working -----Original Message----- From: George Gallen <[email protected]> To: U2 Users List <[email protected]> Sent: Mon, Dec 5, 2011 12:10 pm Subject: Re: [U2] End of Month date routine Haven't checked it, but what happens on 01/31 by adding 31, it should take you > arch, backing up Will give you 02/xx (28 or 29)? George -----Original Message----- rom: [email protected] [mailto:[email protected]] > n Behalf Of Wols Lists ent: Monday, December 05, 2011 3:05 PM o: [email protected] ubject: Re: [U2] End of Month date routine On 05/12/11 19:03, Wjhonson wrote: Does someone have a routine that, no matter what day you run it, returns the nd of Month Date ? (Assume the end of month date, is the calendar end of month date not some crewy business date) Hmmm... no-one seems to have done my approach ... TODAY = @DATE HIS.MONTH.O = OCONV (TODAY, "DMY") ;* strip day off EXT.MONTH.I = ICONV( THIS.MONTH.O, "D") + 31 ;* random day next month EXT.MONTH.O = OCONV( NEXT.MONTH.I, "DMY") ;* strip day off AST.DAY.I = ICONV( NEXT.MONTH.O, "D") - 1 ;* subract one day If you don't have a day in your i/oconv it defaults to 1, so the logic orks. Unfortunately you can't combine the first three lines because here's no number you can pick that will guarantee to land you in next onth whatever today's date :-( Cheers, ol ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
