Re: Last day of the month??

: Hi, : Is there any Informix lib function to get last day of the : month? or how do get that? could someone help? : -Ramki Ramki, What I do to find that last day of the month is use the function MDY() and supply the current month + 1, the first day of the month, and the current year, then once I have that I subtract one day from the date which will give you the last day of the month. If you would like an example I could fish one out for you. It works nice as a small function. -- |======================================================================| | Travis Rayhons trvsryhn@cc.dordt.edu | | Dordt College Computer Services Programmer | |======================================================================|