Hi

I am looking for the equivalent of 'LAST_DAY' function (Oracle) in Informix.

Can any one help?

Thanks

i don't use informix but a quick search of their online docs turned up the MDY() function that can be adapted to what you want

use the expression MDY(MONTH(TODAY),28,YEAR(TODAY)) + INTERVAL (4) DAY to put you into the next month

use MDY(MONTH(XX),1,YEAR(XX)) to get the first day of the next month (where XX is the expression above) and then subtract 1 day

not pretty, but i think that'll do it

rudy
http://rudy.ca/

HI Rudy

Thanks for you suggestion but have come up with more tidy
peace of code. If you are interested here is the solution I am
using:

MDY(MOD(Month(today)+1,12),1,year(today)) -1 units day

Thanks again for you help

Una

hey, neat

you sure that'll work in december? i think you might end up with december 31 of the previous year, eh?

There is one more way......

((TODAY) + 1 UNITS MONTH - (DAY(TODAY)) UNITS DAY)
as LSTDAYOFMNTH

this will eliminate the problem when you hit december...