I am writing some CL's to automate some monthly jobs that are usually submitted through user menus. This particular CL submits a job with the prior month and year as the parms (let's say &YEAR (4) and &MONTH (2)). Then, the CL does a STRQMQRY with the year, month, and day of the last day of that month. Does anyone have a sample of the easiest way to figure out the last day of a particular month (i.e. if run today, the year and month would be 1999 09, and the CL would need to pass 19990930 to the query.)?
I know the method for passing parms with STRQMQRY, I am just wondering if anyone has some code laying around that gives you the last day of the month (accounting for leap years also).
Annuity Board, SBC