When the Table list is based on a Read Data, sometimes the date is shown as formatted in the database.
For example: 2022-03-11
If someone wants to display the German date:
In the view, at the top under "Page Blocks", look for "Text Node" in the table list and paste the line with the date (for example the line: "Model.datum").
Insert in the "Text Node" as text content:
{date:d.m.Y$(var:Model.datum)}
is endformat: 11.03.2022
Finished :-)
you need PHP code to return the month in French:
setlocale(LC_TIME, 'fr_FR.UTF-8');
return strftime('%d %B %Y'); // Outputs: 25 janvier 2025
then use {var:php_action_name} where you want to show the result
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
if you need 17.12.2024 then you should just use {date:d.m.Y}
the solution posted above if for v7 only and will not work in v8
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
if you need to pass a dynamic value to format then you need either to wait for the next update and use this syntax:
{date:Y-m-d={var:row.Datum}}
where {var:row.Datum} is the dynamic date value to be formatted
OR you can format it using a PHP action inside the column instead of the Text node you have now:
echo date("Y-m-d", $this->get("row.Datum"));
You may also return that value instead of "echo" and use it in a Text node as {var:php_action_name}
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
correct, I forgot the need for strtotime
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
