1. Hugh is now back at work, more or less full time, after a slower than expected recovery from his neck surgery early this month. Obviously we have a backlog of support to clear, and are working as hard as we can to take care of it. If you have an unanswered thread more than 3 days old, please post one (and only one) "bump" on it, to move it in to our "last 3 days" list. If you have an unanswered issue in a forum you no longer have access to due to subscriptions timing out, please use the Contact Us form, and provide us with the URL to the thread.

Display a date stored as an integer in date format - How?

Discussion in 'Subscriber Support' started by SimonFinch01, Oct 26, 2007.

Thread Status:
Not open for further replies.
  1. SimonFinch01 New Member

    Level: Standard
    Hi,

    I'm showing some Virtuemart data and one of the fields is a date field stored as an integer of the int(11) type. When I show this data in a table (unsurprisingly) it displays the date as a number. Is it possible to have this number displayed as normal date?

    Cheers,

    Simon
  2. rob Administrator

    Level: Community
    Yeah I had this problem before as well.
    Luckily it was for a project using fabrik 2.0a, so all I had to do was createa new element plugin to deal with cconverting the string into a date.
    For 1.0.4 I think you will need to create a custom template and finesse the output with something like

    Code (text):

    <?php echo date('D d M Y', $row->tablename___elementname);?>
     
    I've just posted in this thread an example of how to create a table template:

    http://fabrikar.com/index.php?option=com_smf&Itemid=9&topic=1435.new;topicseen#new (read right to the end of the thread cos I made a gaff with first example I posted ::) )
Thread Status:
Not open for further replies.

Share This Page