Help

Correcting Date Translations

Topic Labels: Formulas
347 1
cancel
Showing results for 
Search instead for 
Did you mean: 
pantostada
5 - Automation Enthusiast
5 - Automation Enthusiast

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"?
1 Reply 1

CONCATENATE(

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

" de ",

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

" de ",

YEAR{Clinic Date})

)