Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

How to make bulk entry time changes?

November 05, 2013 5:20pm

Subscribe [1]

#1 / Nov 05, 2013 5:20pm

Lesli
92 posts

Hello all,

I want to make time changes to 200+ entries in the publish queue (these are future entries). I know that there’s an SQL Query module, but I’m not so great on SQL syntax, so I’m not sure how to write what I want to. Basically, the conditions and the change I want to make is:

IF date is later than 2013/11/06
AND time is 9:26 AM
THEN change time to 7:15 AM

Is this possible? (I really don’t like the thought of going through and changing all of those by hand, even using the multi-entry edit capabilities.)