Damn February...We need to pull a day from two of the 31 months and give them to February So it will have 30 or 31 days, and almost be like a normal month (all will have 30 or 31 days).
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, December 05, 2011 3:21 PM To: U2 Users List Subject: Re: [U2] End of Month date routine Ditto. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com "Delivering Products, Services and Innovative Solutions" -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, December 05, 2011 3:10 PM To: U2 Users List 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 March, backing up Will give you 02/xx (28 or 29)? George -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Monday, December 05, 2011 3:05 PM To: u2-users@listserver.u2ug.org Subject: 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 End of Month Date ? > (Assume the end of month date, is the calendar end of month date not > some screwy business date) Hmmm... no-one seems to have done my approach ... TODAY = @DATE THIS.MONTH.O = OCONV (TODAY, "DMY") ;* strip day off NEXT.MONTH.I = ICONV( THIS.MONTH.O, "D") + 31 ;* random day next month NEXT.MONTH.O = OCONV( NEXT.MONTH.I, "DMY") ;* strip day off LAST.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 works. Unfortunately you can't combine the first three lines because there's no number you can pick that will guarantee to land you in next month whatever today's date :-( Cheers, Wol _______________________________________________ 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 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users