Datasets formula with other languagues

When i use this formula in a datasets field:

DATE_FORMAT(Fecha, ‘%b’)

I get “jan” instead “ene”. ¿how to change the output to spanish?

thank you

@Peter help please :slight_smile:

You should use $dateFormat in the formula string.
Assuming that Column Fecha has the full date&time and that you want to show three letter representation of a month in Spanish, then you’d do something like this:

If it suppose to be a three letter representation of a day then D instead of M (php date format)

The dateFormat formula function and php date format is explained here - Xibo Documentation | Xibo Open Source Digital Signage
I see there is missing comma between format and language in the manual, we will get that fixed.

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.