Gene Wirchenko wrote: > At 15:38 2009-09-15, Stephen Russell <[email protected]> wrote: > > [snip] > >> Roll another one! > > [snip nasty examples] > >> See why there isn't one? :) > > The same argument can be applied to gomonth(). What is one > month after 2009-02-28? gomonth() says March 28th, but March 31st is > also defensible.
One month after February 28 *is* March 28th, Gene! If you want "end of next month", that's where Ed Leafe's "LastDayOfMonth" function is perfect for this. "One month later" <> "LastDayOfMonth" ... the 30/31 day months are easy examples of this too. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
