 			collection_id)
 		VALUES (
 			#transaction_id#,
-			to_date('#TRANS_DATE#','yyyy-mm-dd'),
+			'#TRANS_DATE#',
 			'#escapeQuotes(TRANS_REMARKS)#',
 			'borrow',
 			'#escapeQuotes(NATURE_OF_MATERIAL)#',

				</td>
				<td>
					<label for="due_date">Due Date</label>
					<input type="text" name="due_date" id="due_date" value="#dateformat(getBorrow.DUE_DATE,"yyyy-mm-dd")#">
				</td>
				<td>
					<label for="lenders_loan_date">Lender's Loan Date</label>
					<input type="text" name="lenders_loan_date" id="lenders_loan_date" value="#dateformat(getBorrow.LENDERS_LOAN_DATE,"yyyy-mm-dd")#">
				</td>
			</tr>
			<tr>

		UPDATE borrow SET
		LENDERS_INVOICE_RETURNED_FG = #LENDERS_INVOICE_RETURNED_FG#,
		LENDERS_TRANS_NUM_CDE = '#LENDERS_TRANS_NUM_CDE#',
		RECEIVED_DATE = '#RECEIVED_DATE#',
		DUE_DATE = '#DUE_DATE#',
		LENDERS_LOAN_DATE = '#LENDERS_LOAN_DATE#',
		LENDERS_INSTRUCTIONS = '#LENDERS_INSTRUCTIONS#',
		BORROW_STATUS = '#BORROW_STATUS#'
	WHERE
