Displaying fomatted mysql date field

in the code window is my code to sdisplay a form that allows a user to edit information, the last diaplayed form element is the Expiry date field, I have tried all sorts of ways to format it so that it displays as DD-MM-YYYY , but no luck, I am probably missing something simple.

Where does the date_format function come into play , before the form code or in the form element below?

<p>
            <label for="Expiry">Expiry <em>*</em></label>
            <input name="Expiry" id="Expiry" size="25" maxlength="100" class="required" value="' . $row_user_edit['Expiry'] . '"/>
            </p>

thanks in advance.

$user_edit = '<div><form id="edituser" method="post"><input type="hidden" name="action" value="updateuser">		
		<fieldset>

		<p>
		<label for="name">Name <em>*</em></label>
		<input id="name" name="name" size="25" maxlength="255" class="required" value="' . $row_user_edit['name'] . '"/>
		</p>

		<p>
		<label for="local_authority_id">Local Authority <em>*</em></label>
		<select style="width:175px;" name="local_authority_id" id="local_authority_id" value="' . $local_auth_name['la_name'] . '">			
			'.$local_authority_option.'
		</select>
		</p>

		<p>
		<label for="school_learning_est_id" >School or Learning Establishment name <em>*</em></label>
		<select style="width:175px;" name="school_learning_est_id" id="school_learning_est_id" value="' . $school_name['School'] . '">'.$tblschool_new_option.'</select>
		</p>

		<p>
		<label for="email">E-Mail <em>*</em></label>
		<input id="email" name="email" size="25" maxlength="100" class="required email" value="' . $row_user_edit['email'] . '"/>
		</p>

		<p>
		<label for="telephonenumber">Telephone Number <em>*</em></label>
		<input name="telephonenumber" id="telephonenumber" size="25" maxlength="100" class="required" value="' . $row_user_edit['telephonenumber'] . '"/>
		</p>

		<p>
		<label for="Expiry">Expiry <em>*</em></label>
		<input name="Expiry" id="Expiry" size="25" maxlength="100" class="required" value="' . $row_user_edit['Expiry'] . '"/>
		</p>

		<p>
		<input class="submit" type="submit" value="Submit"/>
		</p>
    </fieldset></form></div>';

Select allOpen in new window