Storing a DateTime Value in a Sortable Custom Field?

Question

Is there a way to store a custom field value as a datetime so it can be used to order by?

Answer 1

Yes, you can use jQuery DatePicker and save the date, and use query_post to show the postS in order (code also on github):

<?php
//The Query
// exactly than
query_posts('meta_key=start_date&meta_value='.date("Y-m-d"));
// or
// dates less than
// query_posts('meta_key=start_date&meta_compare=<=&meta_value='.date("Y-m-d"));
// or
// date mayor than
// query_posts('meta_key=start_date&meta_compare=>=&meta_value='.date("Y-m-d"));

//The Loop
if ( have_posts() ) : while ( have_posts() ) : the_post();
 echo the_title();
 echo "<br />";
endwhile; else:
endif;

//Reset Query
wp_reset_query();
?>