Hiding a record on a specific date

I have done this on coupons by using -1 day as the expiration text.

<?php echo "Offer Exipres ".date('D, M jS, Y', strtotime('-1 day', strtotime($record['removalDate']))) ?>

Thanks for the reply, Ron. Please can you tell me where I should place your suggested code?

This is my code on the index page:

<table width="100" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <?php foreach ($record['logo'] as $index => $upload): ?>
          <td class="tdOffersIndexLogoCell">
            <a href="<?php echo $record['_link'] ?>">
              <img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" border="0">
              </a>
            </td>
          <?php endforeach ?>
          <td><img src="images/single-pixel.gif" width="13" height="160" /></td>
          </tr>
        <tr>
          <td><img src="images/single-pixel.gif" width="162" height="1" /></td>
          <td><img src="images/single-pixel.gif" width="6" height="1" /></td>
          </tr>
        <tr>
          <td><p class="pBigLabel" align="center"><strong><a href="<?php echo $record['_link'] ?>">
            <?php echo htmlencode($record['offer_headline']) ?>
            </a></strong></p>
            <p align="center" class="pCaptionNoPad"><em>Offer expires&nbsp;<?php echo date("l, F jS, Y", strtotime($record['removeDate'])) ?>.</em></p></td>
          <td>&nbsp;</td>
          </tr>
        </table>

Thanks!

You need to modify the Offer Expires line where you are echoing the remove Date.

Replace this:
<?php echo date("l, F jS, Y", strtotime($record['removeDate'])) ?>

with this:

<?php echo date("l, F jS, Y", strtotime('-1 day', strtotime($record['removeDate']))) ?>

The line would then be:

<p align="center" class="pCaptionNoPad"><em>Offer expires&nbsp;<?php echo date("l, F jS, Y", strtotime('-1 day', strtotime($record['removeDate']))) ?>.</em></p></td>

Hope that solves it for you.

Hi, Ron.

I replaced that line, as you advised, but all that does is change the date that the record is displayed on the site by one less day. So, for example, if the ad is set to expire on April 30, it shows up on the site as expiring April 29: http://www.newhamburg.ca/offers.php. Also, the ad disappears from the site on the date that's shown on the page.

What I'd like to happen is the following:

1. Set the expiry date in CMSB as April 30.

2. The expiry date of April 30 should be displayed on the site; e.g. on these pages - http://www.newhamburg.ca/offers.php and http://www.newhamburg.ca/offersDetails.php?Dolman-Eyecare-Centre-18.

3. The ad would be hidden from May 1, not April 30; i.e. even if the offer runs out on April 30, the ad should still show up and not be hidden yet.

Regards,

Nigel Gordijk

Well, the date you should be entering is the REMOVAL DATE (May 1) and not the expiration date of April 30.  As long as the administrator understands that the expiration date that is published is calculated from the removal date it works fine.  I always put a note above the removal date field as a reminder and have never had a problem. (see attached jpg)

I feel like such a knucklehead - your solution seems so obvious to me now that you pointed that out!

Thanks for your suggestions and patience.