using custom date field with date picker plugin

-- HikaShop version -- : 2.3.1
-- Joomla version -- : 3.3
-- PHP version -- : 5X

Hi

I am using a custom field and applying advance date picker plugin with field type "advance date picker" for table "product". I am setting format as "D d M Y".
When I select 30 June 2014, it writes the value in the database as "20140630000000".

I am using this custom date field by using $row->course_start_date. However it prints out the string 20140630000000, rather than the Mon 30 Jun 2014.






Could you advise how you are formatting this?

Thanks

Hi,

To display the custom field, you have to use the HikaShop field class and call the "show" function with the field object.
You can't use a raw value like that with the custom fields.

The date is stored in a fixed format in order to be displayed dynamically.
The other date custom field store the pre-formated date in the database, so it does not allow you to sort or filter easily (depending the format you use).
The "pro" is that you can display the raw value from the database, the "con" is that you can't change the format or use it in code/sql.

Regards,

HI Jerome

Thank you for your response. Could you please give me an example of how to use this show function.

Thanks

Patrick

Like that:

Hi Nicolas and Jerome

This worked.

Thanks for your assistance.

Patrick