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