I had create a custom field “date” with this format 16/09/2013 (d/m/Y). How can i compare date and show only post with date from today ? This is my query that don’t work !! $args = array( ‘posts_per_page’ => 100, ‘meta_key’ => ‘date’, ‘orderby’ => ‘meta_value’, ‘order’ => ‘ASC’, ‘meta_query’ => array( array( ‘key’ => … Read more
Closed. This question is off-topic. It is not currently accepting answers. Your question should be specific to WordPress. Generic PHP/JS/SQL/HTML/CSS questions might be better asked at Stack Overflow or another appropriate Stack Exchange network site. Third party plugins and themes are off topic, they are better asked about at their developers’ support routes. Closed 4 … Read more
I have a custom MySQL table with two columns that look like this: `timestamp_created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `datetime_created` DATETIME DEFAULT CURRENT_TIMESTAMP, When retrieving these values using $wpdb, I would like to know in what timezone the result will be, and whether I can have the result be in UTC: $row = $wpdb->get_row(“SELECT * FROM `test`”, … Read more
Is there a plugin for WordPress that will change a post’s category based on how long that post has existed? I have seen other WordPress plugins that use a library called “simple pie” to manage a wp-blog’s timed tasks, is there one that does something like this? 1 Answer 1 Don’t know of a plugin … Read more
I’ve created a custom post type for events that uses a custom field to retrieve the date for the event. It works ok and I’m able to filter the displayed results using meta_compare to compare the date value to the current date. So far so good. I can also filter the admin end to display … Read more
This seems like a fairly common problem, but I’m posting this as I’ve yet to find a solution to my problem here on WP Answers – any help is HUGELY appreciated! Ok – so I have a custom post type of ‘events’ where I capture the date of the event using a custom field and … Read more
How would I bulk change posting date? I want to change about 20 post publish dates at a time in one click 2 Answers 2 Post date/time can’t be changed via the Quick-Edit bulk editor. You might edit the SQL directly, if you’re comfortable running a query in PHPMyAdmin. Or, you could search for a … Read more
Is there a way to display posts, scheduled for the future? I want to use the published data as an event date and time, which is obviously in the future. I still would like to use these posts for a loop, and for single pages. 2 Answers 2 $args = array( ‘post_status’ => “future”, ‘order_by’ … Read more
QUESTION This is following a previous question that was graciously answered by Milo earlier here – How to sort CPT by custom meta value (date), and return posts month by month In short, I’m having some issues with properly formatting my custom meta box date’s in a few areas… Namely, in the back-end in my … Read more
When I run a simple php file called test.php (placed in the root of the wp installation) that contains something like that: <?php echo date(‘H:i:s’); ?> The result is right: 15:30:00 and the timezone is set also correctly to Europe/Prague which is UTC+2 time However, if I place the same line within my e.g. footer … Read more
