Translating English date to Spanish date

[smsherman]

I need to develop a formula that will translate an English numerical date into the appropriate Spanish equivalent written out in long form.

Thus, I need to turn 01/05/2005 (January 5, 2005) into "5 de enero, 2005. (enero is the Spanish word for Jan)

Any suggestions on a plan of attack?

Is there a way to substitute elements within the date with other character sets?

Your help is always appreciated, thank you. Crystal 9 platform.

 

[vidru]

You could write a formula or a custom function to return a Date as the Spanish date.

StringVar Array Months := ["enero", "febrero", "marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre"];

ToText(Day({Table.DateField}),0) + " de " + Months[Month({Table.DateField})] + ", " + ToText(Year({Table.DateField}),0,"");

-dave

 

[smsherman]

Simply brilliant! Thank you, thank you, thank you.

May you live a long life and keep all your hair and teeth!