Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Correcting Date Translations

471 0
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})

)