Forums

Hi,

How to show a timestamp in date format in a table list ?

I tried
Created:{date:timestamp_date_created}
and appears several dates, i thinck it's possible to select one format...

Thanks

Hi Chris,

You have a time stamp ? how do you get its value ?

Please try this:

{date:Y-m-d H:i:s$(var:read_data_name.model.timestamp_field)}

This works with the latest update only because you can pass parameters to the functions calls.

Best regards,
Max

Hi Max,

I'm in the context of a list view (table),

in columns list :

o_order.order_created:Created

shows the timestamp from database

Thanks
Regards

Hi Chris,

So you need this:

o_order.order_created:{date:Y-m-d H:i:s$(var:read_data_name.row.o_order.order_created)}

in the "Columns views"

Best regards,
Max

Hello Max,

In column list i put o_order.order_created:Created, if not the created date doesn't appear and now, in each row shows the date now not the created date!

in columns views
o_order.order_created:{date:Y-m-d H:i:s$(var:read_hikaorder.row.o_order.order_created)}

sorry i don't understand

Regards
Chris

Hi Chris,

What happens when you use {var:read_hikaorder.row.o_order.order_created} ? does it display the order date in each row ? in which format is the date ?

Best regards,
Max

Hi Max,

in columns list
order_created:Created

if o_order.order_created:Created display timestamp in each row and different

in columns view

order_created:{date:Y-m-d H:i:s$(var:read_hikaorder.row.o_order.order_created)}
display date now in good format
2017-05-29 07:26:13

order_created:{date:Y-m-d H:i:s$({var:read_hikaorder.row.o_order.order_created})}
order_created:{date:Y-m-d H:i:s${var:read_hikaorder.row.o_order.order_created}}
display error
DateTime::__construct(): Failed to parse time string (({var:read_hikaorder.row.o_order.order_created) at position 0 ((): Unexpected character

Thanks
regards

Hi Chris,

Please use () inside {}, you can not use nested {{}}, like this:

order_created:{date:Y-m-d H:i:s$(var:read_hikaorder.row.o_order.order_created)}

Best regards,
Max

I know,

order_created:{date:Y-m-d H:i:s$(var:read_hikaorder.row.o_order.order_created)}
display date now in good format but always now() not the real date
2017-05-29 07:26:13

regards

Hi Chris,

Maybe you should try:

o_order.order_created:{date:Y-m-d H:i:s$(var:read_hikaorder.row.o_order.order_created)}

Best regards,
Max

Hi Max,

idem the column display the dat"e of now in each row

Thanks
Regards

Hi Chris,

Please post a screenshot of the table settings at the moment.

Best regards,
Max