this is my formula :
'This is to certify that' + ' ' + CStr(Fields.last + "," + Fields.first) + ' ' + 'with PagIBIG ID no.' + ' ' + Fields.[id_pag] + ' ' + 'has been working with us from' + ' ' + Fields.[eff_date].date + ' ' + "to present. The Pag-IBIG premium deducted from his/her period of employment with us were remitted with the employer's as follows:"
This is to certify that SurName,First Name with PagIBIG ID no. 5676576545435 has been working with us from "1/1/2006 12:00:00 AM" to present. The Pag-IBIG premium deducted from his/her period of employment with us were remitted with the employers as follows
the bold text output should be Jan 1, 2006 and not display also the time