Future publish date on content page not properly working

Hi Chandra,

Just a few things to check.

• Could it be an issue with date format. For example future date might be 3rd August and you're putting the date as 03/08/2021, but the system is set to US format and is interpreting this as 8th March (meaning it is in the past, not the future).
• What happens if you set the year to 2022?
• After you have saved the page, you mention you're seeing the old date in the database. But what do you see in the Content tab? Your new date or the old date as per the DB?

Hi @Jake

Thanks for the response.

• Could it be an issue with date format. For example future date might be 3rd August and you're putting the date as 03/08/2021, but the system is set to US format and is interpreting this as 8th March (meaning it is in the past, not the future). I checked, this should not be the case because the date i set is '5/27/2025 9:34:41 PM'

• What happens if you set the year to 2022? It is being published and the status on General Tab is as Published: Yes

• After you have saved the page, you mention you're seeing the old date in the database. But what do you see in the Content tab? Your new date or the old date as per the DB? In the content tab i am seeing the new date(future) as per added . But it is different in database. In database, the date is previously selected non-future date. I query this table SELECT DocumentPublishFrom FROM CMS_Document Where DocumentID=123

Thanks, Chandra

Isn't it possible you are using versioning without workflow? Because your description fits the behavior when using workflow or versioning with content scheduling. Please see this article on the same topic. I would say that there is currently published some version of the page - so this one is displayed. Then, you create new edited version and set its publishing date into the future. So, this latest editing version is still waiting to be published. And once the date and time will come, the edited version will become the latest published version and it will also change the values in the DB. (FYI, I would recommend getting familiar with the DB structure too).
That being said, if you want to hide the page from the live site, unpublish it then you need to set the Publish To date into past. This way the latest edited version will become the latest published version but based on the date it will be unpublished from live. Then, clear the Publish to field and set new Publish from date, save, done.