1. Fabrik 3.7 is now available. This version contains critical security updates, please update as soon as possible. Please remember to backup your site before updating, we also recommend testing your updates on development sites if possible.
  2. We had to restore the site around midday (CST) on Wed 7/26 from a backup approximately 8 hours old. So a few posts in the forums were lost. You may want to check to see if you need to re-post anything.

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

    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

    rob Administrator Staff Member

    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