expires date on product info page

I'm trying to add expires date on product info page:

 <?php echo sprintf(TEXT_DATE_END, zen_date_long($products_id[expires_date])); ?> 

this on tpl_product_info_display, and

define('TEXT_DATE_END', '<font color="#ff0000"><b>This specials end at date  %s</b></font>');

on language definition.
But, unfortunately, on product info page customer can see onlytext, without expires date.
Where I wrong?

Where is "this" coming from?:```
$products_id[expires_date]

It's wrong?
in special table I see this field expire_date
Help me: suggest me the code.

Specials-expiry data isn't normally available to the product-info page. To add it, you can use the following, adapted from your earlier post:

1. keep the language-file update you suggested for TEXT_DATE_END.

2. in tpl_product_info_display.php:

<?php if ($product_special_expires != '') echo sprintf(TEXT_DATE_END, zen_date_long($product_special_expires)); ?> 

3. in /includes/modules/pages/product_info/main_template_vars_product_type.php
   find this line:// Nothing special to do here for primary product_info typeadd this below it:```
   $specials_query = "select expires_date
   from " . TABLE_SPECIALS . "
   where status = '1'
   and products_id = '" . $_GET['products_id'] . "'
   and ((now() <= expires_date and expires_date != '0001-01-01')
   or (now() >= specials_date_available and specials_date_available != '0001-01-01'))";

   $specials = $db->Execute($specials_query);
   $product_special_expires = ($specials->RecordCount() > 0) ? $specials->fields['expires_date'] : '';

You're great!
Thank's so much!

Do you think is this possible to do with salemaker price? I'm trying, but I can't see the solution. Can you help me?

Hi,
Thank you for this clear answer.

The display of the expires date is an important information for us (and the customers !).

I also need to display this information on sereval pages (specials sidebox, specials page and product_info page).

I think that it would be nice to display the "expires date" with the function
zen_get_products_display_price().
Perhaps with optional arguments, for displaying or not the date, and the date format.
Or perhaps with a new function (ie zen_get_products_display_price_full()) that calls zen_get_products_display_price().

Thanks again.

DrByte:

Specials-expiry data isn't normally available to the product-info page. To add it, you can use the following, adapted from your earlier post:

1. keep the language-file update you suggested for TEXT_DATE_END.

2. in tpl_product_info_display.php:

> 
> 3. in /includes/modules/pages/product_info/main_template_vars_product_type.php
> find this line:```
// Nothing special to do here for primary product_info type
```add this below it:```
    $specials_query = "select expires_date
                       from " . TABLE_SPECIALS . "
                       where status = '1' 
                       and products_id = '" . $_GET['products_id'] . "'
                       and ((now() <= expires_date and expires_date != '0001-01-01')
                             or (now() >= specials_date_available and specials_date_available != '0001-01-01'))";

    $specials = $db->Execute($specials_query);
    $product_special_expires = ($specials->RecordCount() > 0) ? $specials->fields['expires_date'] : '';

I can't find solution: I don't find the filed for salemaker expires date.
Can you help me to write expire sale date on product info page?