need letters

Problem Description : 

Re-set need letters for specific date

 Resolution : 

Run the following sql to update gurmail for today's date only

UPDATE gurmail

SET gurmail_date_printed = NULL

--select * from gurmail

where GURMAIL_LETR_CODE = 'NEED1'

and gurmail_term_code = '201208'

and trim(GURMAIL.GURMAIL_DATE_PRINTED) = '24-APR-12'

 Revision Date : 9/28/2012