Re: Last day of month..

Posted in 1998

Octav Chiriac — Mon, 21 Sep 1998 11:34:21 +0300 (EETDST) — source: Informix-list mailing list archive (1991-1998)

SUNIL S. SINGH wrote: > >Hi All !! > >Is there any function or technique to find last day of month >ie 29 or 28 or 30 or 31 for a particular date(dd/mm/yy) > Let's say our date is m_date: DAY(MDY(MONTH(m_date), 1, YEAR(m_date)) + 1 UNITS MONTH) - 1 UNITS DAY) Hope it helps, Octav -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 20 96 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com