I'm trying to extract records from a table for all customers that have a date greater than 12 months ago, but it must be the first of that month. For example, if today is 09/29/2009, I want all customers with a start date greater than 09/01/2008. I know how to get customers with dates greater than 12 months ago, but don't know how to get to the first of the month. I'm using QMF.

This query against the employee table in the sample database works on DB2 LUW, but should work on mainframe also:

select * from employee where hiredate >= substr(char((current_date - 1 years),iso),1,7)||'-01'

try:

... WHERE customer_date > LAST_DAY ( current date ) + 1 DAY - 13 MONTH