lookup wizard

This topic is locked

lookup wizard	7/2/2007 7:59:49 AM
PHPRunner General questions
B bobby123 authorDevClub member I have a table 'customer' which has a date field, I have another table which have a lookup wizard linked to this date field. My problem is that my date format for the 'customer' date field is DD/MM/YYYY but the lookup wizard keeps changing the format to YYYY-MM-DD. How do I stop it doing this. One other question I have been testing some HTML editors to try and build some better UI templates. I have fould this very buggy, the templates provided with phprunner are okay but they are a bit basic looking. Do you have any suggestions for editors that work well with phprunner Thanks Bobby


J	Jane 7/2/2007
	Bobby, try to use following code as Custom expression in the Display field dropdown box on the "Edit as" settings dialog on the Visual Editor tab^ date_format(FieldName,'%d/%m/%Y') where FieldName is your actual field name.