Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Correcting Date Translations

832 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
kuovonne
18 - Pluto
18 - Pluto

CONCATENATE(

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

" de ",

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

" de ",

YEAR{Clinic Date})

)