I'm working on a template for a Pages database and would like to customise how the publish date displays. I know I can use

{datetime="$row->record_publish_date"}

to get the full date but I'd like to be able to produce the day, month and year components separately. I know a little bit about how PHP formats dates but I'm afraid that I don't know how to apply that knowledge in this environment. Could anybody kindly offer some pointers?

I have a more strange problem. In one database the code works for the date and does not work in another:

{datetime="$record->record_publish_date"}

 

4 hours ago, sobrenome said:

I have a more strange problem. In one database the code works for the date and does not work in another:

{datetime="$record->record_publish_date"}

 

 

{datetime="$record->_publishDate"}

5 hours ago, newbie LAC said:

{datetime="$record->_publishDate"}

Did not work.

😕

When I do 

print_r ($record);

I get:

[record_edit_time] => 1562080148 
[record_publish_date] => 1562077740

So the data is there.

The problem is with the datetime function:

{datetime="$record->record_publish_date"}
{datetime="$record->record_edit_time"}

How to solve it?

Now it’s working. I suppose was something related to cache. Thanks.