Formula to convert date into quarter add display it in full text

[Remy_K]

Hello,

I would like a formula to convert date fild  into quarter and  add display it in full text.

Exemple:

Dates between 01/01/23 to 31/03/23  will display " first quarter"

Dates between 01/04/23 to 31/07/23  will display " second quarter"

and so on...

Thanks for your precious help.

Remy

[Grunty]

---

@Remy_K wrote:

I would like a formula to convert date fild  into quarter and  add display it in full text.

Exemple:

Dates between 01/01/23 to 31/03/23  will display " first quarter"

Dates between 01/04/23 to 31/07/23  will display " second quarter"

and so on...

---

Care what you wish! 😲

[TheTimeSavingCo · Accepted solution]

Try using 'Qo' with the formula 'DATETIME_FORMAT()'

Here's a link to the specifiers available for use with DATETIME_FORMAT()

[Grunty]

Your suggestion would work for a conventional request. However I don’t think it would work for the present case.
He’s asking for a formula that assigns July dates to "second quarter" 👽

[Remy_K]

Thank you: 

DATETIME_FORMAT(

  SET_LOCALE({Date},'fr'), 

  'Qo'

)

This works But only returns 1er,2,3,4 instead of 1er,2éme,3éme,4éme. Weird...

[Remy_K]

Thank you