If found the following bit of code here in a topic with subject "Display Expiration Date in CB Subscription Module" It works great for active subscribers, but if a user's subscription has expired it give a date of December 31, 1969. I check the db and the test expired user has a status of X and a valid(expired) date/time in the expired column. Any one have any ideas?
Thanks,
David

<div id="expiry_notice">
< ?php

$db = JFactory::getDbo();
$query = $db->getQuery( true );

$query = "SELECT expiry_date FROM #__cbsubs_subscriptions WHERE user_id = '" . $_CB_framework->myId() . "' AND status = 'A'";

$db->setQuery($query);

$result = $db->loadResult();

$dt = strtotime($result);

echo "Membership Valid Until: <br />" . date("F j, Y", $dt);

?>
< /div><!--#expiry_notice-->