List Manager Forum

Hi,
yes, the php date function only shows the output in English, there was a date format function that allowed to set a different locale but it has been deprecated for PHP8. In order to show different texts for week dates or months you can try a different approach:

- Set the field type as 'calculated sql'

- Insert a query at the Data/Values->Calculated Query configuration

SELECT DATE_FORMAT(yourfield,'%d - %b - %Y','fr_FR') AS yourfield FROM yourtable where id_internal=##id_internal##;

Replacing yourfield and yourtable for your proper field and table names. Instead of 'fr_FR' you can set your desired locale. Please note the date format function from your database has different characters to set the output configuration, you can check them here:

https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_date-format

So at this example '%d - %b - %Y' will print values like

15 - avr - 2024


Hope this helps, regards
Guillermo V.
Moonsoft Team