XF 2.1 Proper use of date_from_format

[Cupara]

Here is the issue, I have a date format of

2019-12-24T15:46:23.978Z

and I'm needing to form that into a proper date and time in my XenForo addon. This is being pulled using JSON.

Thanks to @Sim in another thread, we figured out so far the following:

{{ date_from_format("Y-m-d\TH:i:s:u\Z", $posts.created_at) }}

In the screenshot, there should be a properly formed date and time between the icon and dash but instead I'm left with a blank.

I really want to get this solved so that I can move on to preparing this addon for release.

 

[Cupara]

Any help greatly appreciated.

 

[Cupara]

Since there has been no feedback, I guess I'll have to go with the method I wanted to avoid and that inserts the JSON feed to the database while updating the data to a proper unixtime then pulling from the database so it displays correctly.

 

[Orit]

In case anyone else needs this,
the following thread may help :

XF 2.1 - Converting UTC datetime to readable datetime

I have this type of DateTime: 2020-10-13T22:39:00.711Z This is in UTC and I need to convert it to: Y-m-d i:s.u So far I have this in my template: {{ date(date_from_format("Y-m-d\TH:i:s.u\Z", '{$posts.created_at}'), '') }} How do I get this to convert and display properly? Right now it...

xenforo.com

Basically, the function to change the date format in a template is:
{{ date(date_from_format("Y-m-d", $variable), 'd/m/Y') }}
Y-m-d meaning the php format of the variable (in my case that was the format).
$variable meaning the variable containing the date.
d/m/Y meaning the requested date format.

Good luck