Display Customer Accounts Setup in a Certain Period

— Display Customer Accounts Setup in a Certain Period (month)

— Variables Below …
— Change the XX in month(creatddt) to the desired month (period)
— Change the XXXX in year(creatddt) to the desired year
— The query will display the customer account number and customer name

select custnmbr, custname  from rm00101 where month(creatddt) = ‘XX’ and year(creatddt) = ‘XXXX’