I'm using a custom field called 'date' as place for the client to select a date for events, then using a query to sort the posts so they appear in date order on the front end.
the query is...
<?php query_posts('cat=3&showposts=5&order=asc&orderby=meta_value&meta_key=date'); $i=0; ?>
now to sort the posts correctly the date format needs to be yyyy-mm-dd,
I'd like to also display the contents of the custom field on the front end of the site as dd-mm-yyy (as people are used to reading it in the UK) or, even better, as a fully written out date (eg 9th february 1980)
Anyone know any sneaky way to do this without the client haing to select the date twice in 2 seperate custom fields?