Title: Feature req: bulk changing date
Last modified: August 19, 2016

---

# Feature req: bulk changing date

 *  [substitute](https://wordpress.org/support/users/substitute/)
 * (@substitute)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/feature-req-bulk-changing-date/)
 * Hi
    Yeah what if you have dozens of posts you want to set to another date? You
   have to it one by one… Would be good to be able to that in one go.
 * Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/feature-req-bulk-changing-date/#post-1377097)
 * Until that gets added to core, here’s one example of doing it with MySQL commands
   in something like [phpMyAdmin](http://codex.wordpress.org/phpMyAdmin)
 * SQL to increment dates in wp_posts
 *     ```
       UPDATE wp_posts
       SET post_date = DATE_ADD( post_date, INTERVAL 9 MONTH ),
       post_date_gmt = DATE_ADD( post_date_gmt, INTERVAL 9 MONTH ),
       post_modified = DATE_ADD( post_modified, INTERVAL 9 MONTH ),
       post_modified_gmt = DATE_ADD( post_modified_gmt, INTERVAL 9 MONTH )
       ```
   
 *  Thread Starter [substitute](https://wordpress.org/support/users/substitute/)
 * (@substitute)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/feature-req-bulk-changing-date/#post-1377161)
 * Nice but I wouldn’t know how to do that. I’ll just wait for the core to be updated
   if ever.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Feature req: bulk changing date’ is closed to new replies.

 * In: [Requests and Feedback](https://wordpress.org/support/forum/requests-and-feedback/)
 * 2 replies
 * 2 participants
 * Last reply from: [substitute](https://wordpress.org/support/users/substitute/)
 * Last activity: [16 years, 4 months ago](https://wordpress.org/support/topic/feature-req-bulk-changing-date/#post-1377161)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics