Re: How to get the end value of month

Posted in 2006

Doug Lawry — Tue, 9 May 2006 11:06:01 +0100 — source: Usenet: comp.databases.informix

"Prateek Jain" <prateekvjain@gmail.com> wrote in message news:mailman.139.1147157764.848.informix-list@iiug.org... > Hi, > I want to execute query for that i require end date of the month, > > suppose if the month is April then it should return 30 > if March then in should return 31 > Is there any inbuilt function for that which give the end date of the month > > Regards > Prateek.Jain DATE( MDY(MONTH(TODAY),1,YEAR(TODAY)) + (1 UNITS MONTH) - (1 UNITS DAY) ) -- Regards, Doug Lawry www.douglawry.webhop.org