1. Hugh is (technically) on vacation for the rest of September, travelling to Europe for his son's wedding in England, and to meet up with Rob in La Rochelle, France. He will be checking the forums most days, and providing some support, but his time will be limited, and he will be unable to do any custom coding work. Apologies in advance for any inconvenience.

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

    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?


  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