Hi Frank,

Sorry I didn't make it clear in my original question. It's a monthly batch job. I will get the date when the job run. What I am looking for is the last day for the month and the year of the date because I need to come up with year-mm-lastday in my WHERE clause as the endday.

Do you know any functions or source code to calculate the last day for the month based on a date?

Thanks,

yp