How to change article submission date and published date

For some OJS themes, the date data are displayed on the detail article page or the journal index page. This theme usually uses a date automatically retrieved from the OJS database. To change this data, you need to take a technical approach to make changes to the OJS database.

The following methods will be run on OJS version 3.2.x or 3.3x. These steps may be different for other OJS versions.

We provide two ways to edit the submission metadata (article submission date and accepted date)

Using the Database modification #

Accessing and modifying the OJS database directly required a skilled and experienced person. We don’t take any responsibility for any unwanted result in the database caused by following this article.

The following steps are described in detail :

Editing the submission date #

1. Open The Phpmyadmin on your server, and select the database used by your OJS.
   
   
   
2. Determine the ID of the article by looking at the end number when you access the article detail page.
   
   For example, in this case, we will use the number 60.
   
   
3. In the next step, you need to open the submission table and write in the query column the following command:
   
   
   
4. Run the query by clicking “Go“
   
   
   
5.  Edit the date_submitted column by double-clicking on the value of that column
   
   
    and Save

Editing the publication date of the article: #

Please do the same method as the above steps until step 2

1. Run the following query
   
2. Then edit the value in the “date_published” column
   
   
   
3. Save the change

Bonus : 

You can also edit the article publication date by using OJS or without access to the database editor / PHPMyAdmin. This can be done by accessing the article data on the OJS backend: 

1. Unpublished the article First / Make sure the status is Unscheduled
   

   

2. Access the Issue tab 
   

   

3. Edit the Date Published section 
   

   

   The default value will be empty as the date published will be taken from the issue publication date. 

Using OJT Plus Premium Plugin #

Because making any modification required some knowledge of the database and SQL and it may have some risk when you are making any change in the database value. We create a plugin that allows you to edit the modification of submission date and Accepted date easily without the need to access the database or run any SQL query.

OJT plus premium is a bundled plugin created to add the most needed features in OJS, such as adding a notification for the visitor on your journal front, adding a Youtube video abstract, and modifying the submission and accepted date easily.

For the context of modifying the submission and accepted date, click here for more detail.

Muhammad Al Madani

Hello! I'm Almadani, Customer support OJS from Openjournaltheme. Have a passion for helping solve publisher problems, have knowledge and experience related to the use of OJS, OMP and Eprints.