Sorting entries by week # - formula not correct

[pantostada]

Hi there,

Using the formula

DATETIME_FORMAT(SET_LOCALE({Clinic Date}, 'es'), 'dddd D MMMM YYYY')

to translate dates into Spanish, however, the translations are missing "de" between date, month, year. I'm having trouble adjusting the formula so that date read. For example, the translation is working well and producing "jueves 30 marzo 2023" however, I need it to translate to say "jueves 30 de marzo de 2023"

I've tried problem solving with formulas I found in AT trainings, but it's not working for me. How can I update the formula to include the word "de"?

[kuovonne]

CONCATENATE(

DATETIME_FORMAT(SET_LOCALE({Clinic Date}, 'es'), 'dddd D'),

" de ",

DATETIME_FORMAT(SET_LOCALE({Clinic Date}, 'es'), 'MMMM'),

" de ",

YEAR{Clinic Date})

)