This is my scenario: I will set up a special price for current day only and I would like to mention in Frontend a text message when the offer is available.
By default when you select a date in Magento backend (Product editing page), you are not allow to set up the time too. If you look into the database both SpecialPriceFromDate and SpecialPriceToDate has the same time set up at 00:00. If they have the same value there is an issue, you cannot compare current visitor time with SpecialPriceToDate.
- SpecialPriceFromDate = 2016-08-27 00:00:00
- SpecialPriceToDate = 2016-08-27 00:00:00
- Current Visitor Time = 2016-08-27 16:00:36
I can do some statements inside the template file, by creating a variable for end of the day and adding 86399 to SpecialPriceFromDate, then evaluating it with current visitor time. It works but it is not looking good.
I would like to ask you how if I can change the calendar in Product editing page in order to set up the time too. In this way the time is very precisely.
By the way, product special Price appears correctly in frontend if both dates are equal.