# Datasets formula with other languagues

**URL:** https://community.xibo.org.uk/t/datasets-formula-with-other-languagues/25503
**Category:** Other
**Created:** [August 4, 2021, 3:01am UTC](https://community.xibo.org.uk/t/datasets-formula-with-other-languagues/25503 "2021-08-04T03:01:08Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Victor\_Araya\_V](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/victor_araya_v/32/8238_2.png) [@Victor\_Araya\_V](https://community.xibo.org.uk/u/Victor_Araya_V)
#### Post date: [August 4, 2021, 3:01am UTC](https://community.xibo.org.uk/t/datasets-formula-with-other-languagues/25503/1 "2021-08-04T03:01:09Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Victor\_Araya\_V](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/victor_araya_v/32/8238_2.png) [@Victor\_Araya\_V](https://community.xibo.org.uk/u/Victor_Araya_V)
#### Post date: [August 21, 2021, 1:33am UTC](https://community.xibo.org.uk/t/datasets-formula-with-other-languagues/25503/2 "2021-08-21T01:33:11Z")

</div>

@Peter help please 🙂

---

<div class="post-metadata">

### Author: ![Peter](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/peter/32/8154_2.png) [@Peter](https://community.xibo.org.uk/u/Peter)
#### Post date: [August 23, 2021, 9:45am UTC](https://community.xibo.org.uk/t/datasets-formula-with-other-languagues/25503/3 "2021-08-23T09:45:58Z")

</div>

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:  
`$dateFormat(Fecha,M,es)`

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](https://xibo.org.uk/manual/en/media_datasets.html)  
I see there is missing comma between format and language in the manual, we will get that fixed.

---

<div class="post-metadata">

### Author: ![system](https://community.xibo.org.uk/uploads/default/original/2X/a/a8759c2d8cc561474733895ac75beeb830f5d8ca.png) [@system](https://community.xibo.org.uk/u/system)
#### Post date: [November 22, 2021, 3:46pm UTC](https://community.xibo.org.uk/t/datasets-formula-with-other-languagues/25503/4 "2021-11-22T15:46:04Z")

</div>

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