Switching Date Fields from English to Spanish.

[niktemadur]

Hello there. I've got a bit of a puzzle, maybe somebody has been through this situation and can help me out. Because frankly, I am stumped.

I've created a large database in Spanish. Within the database is an intricate sequence of Date Fields and Calculation Fields (for Dates), displayed by Filemaker default in English. Up until now, this little detail has been of little to no consequence.

However, I now need to print out some Records, and they have to have the Dates displayed in Spanish.

For example, I need a Calculation Field result to display:

"Marzo 11, 2005"

Instead of:

"Marzo 11, 2005"

Is there a way to change the language?

Thank you!

[niktemadur]

Hello there. I've got a bit of a puzzle, maybe somebody has been through this situation and can help me out. Because frankly, I am stumped.

I've created a large database in Spanish. Within the database is an intricate sequence of Date Fields and Calculation Fields (for Dates), displayed by Filemaker default in English. Up until now, this little detail has been of little to no consequence.

However, I now need to print out some Records, and they have to have the Dates displayed in Spanish.

For example, I need a Calculation Field result to display:

"Marzo 11, 2005"

Instead of:

"Marzo 11, 2005"

Is there a way to change the language?

Thank you!

[niktemadur]

Hello there. I've got a bit of a puzzle, maybe somebody has been through this situation and can help me out. Because frankly, I am stumped.

I've created a large database in Spanish. Within the database is an intricate sequence of Date Fields and Calculation Fields (for Dates), displayed by Filemaker default in English. Up until now, this little detail has been of little to no consequence.

However, I now need to print out some Records, and they have to have the Dates displayed in Spanish.

For example, I need a Calculation Field result to display:

"Marzo 11, 2005"

Instead of:

"Marzo 11, 2005"

Is there a way to change the language?

Thank you!

[-Queue-]

Include this in your calc to convert the month.

Choose( (Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MonthName(datefield), 3 ), 0, 1 ) + 2) / 3 - 1, "enero", "febrero", "marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre" )

[-Queue-]

Include this in your calc to convert the month.

Choose( (Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MonthName(datefield), 3 ), 0, 1 ) + 2) / 3 - 1, "enero", "febrero", "marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre" )

[-Queue-]

Include this in your calc to convert the month.

Choose( (Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MonthName(datefield), 3 ), 0, 1 ) + 2) / 3 - 1, "enero", "febrero", "marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre" )

[niktemadur]

What an amazing workaround! I've never seen anything quite like it, never in a thousand years would have figured it out.

Thank You!!!

Or maybe I should say

Muchas Gracias!!!

[niktemadur]

What an amazing workaround! I've never seen anything quite like it, never in a thousand years would have figured it out.

Thank You!!!

Or maybe I should say

Muchas Gracias!!!

[niktemadur]

What an amazing workaround! I've never seen anything quite like it, never in a thousand years would have figured it out.

Thank You!!!

Or maybe I should say

Muchas Gracias!!!

[niktemadur]

For anyone that might need this at any time, here's how I did the full calculation for getting the result in Spanish. Mine's a bit complex, with dates piled up one on top of another and whatnot, so I'll make the example less complicated, so that just the general idea comes across.

Let's say you have a Birthdate Field. One of your Records displays, let's say, "March 11, 2005", and you want to create another Field that will display "Marzo 11 de 2005".

1. Create a Calculation Field. Calculation Result must be in Text.

2. Type this: (Choose( (Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MonthName(Birthdate), 3 ), 0, 1 ) + 2) / 3 - 1, "Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre" )) & " " & Day(Birthdate) & " de " & Year(Birthdate)

[niktemadur]

For anyone that might need this at any time, here's how I did the full calculation for getting the result in Spanish. Mine's a bit complex, with dates piled up one on top of another and whatnot, so I'll make the example less complicated, so that just the general idea comes across.

Let's say you have a Birthdate Field. One of your Records displays, let's say, "March 11, 2005", and you want to create another Field that will display "Marzo 11 de 2005".

1. Create a Calculation Field. Calculation Result must be in Text.

2. Type this: (Choose( (Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MonthName(Birthdate), 3 ), 0, 1 ) + 2) / 3 - 1, "Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre" )) & " " & Day(Birthdate) & " de " & Year(Birthdate)

[niktemadur]

For anyone that might need this at any time, here's how I did the full calculation for getting the result in Spanish. Mine's a bit complex, with dates piled up one on top of another and whatnot, so I'll make the example less complicated, so that just the general idea comes across.

Let's say you have a Birthdate Field. One of your Records displays, let's say, "March 11, 2005", and you want to create another Field that will display "Marzo 11 de 2005".

1. Create a Calculation Field. Calculation Result must be in Text.

2. Type this: (Choose( (Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MonthName(Birthdate), 3 ), 0, 1 ) + 2) / 3 - 1, "Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre" )) & " " & Day(Birthdate) & " de " & Year(Birthdate)

[-Queue-]

Note that you could make Choose( (Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MonthName(BirthDate), 3 ), 0, 1 ) + 2) / 3 - 1, "enero", "febrero", marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre" ) its own calc and then each instance of conversion would only require

PositionCalc & " " & Day(BirthDate) & " de " & Year(BirthDate)

Also, months are not capitalized in Spanish, which is why I left them as lowercase.

[-Queue-]

Note that you could make Choose( (Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MonthName(BirthDate), 3 ), 0, 1 ) + 2) / 3 - 1, "enero", "febrero", marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre" ) its own calc and then each instance of conversion would only require

PositionCalc & " " & Day(BirthDate) & " de " & Year(BirthDate)

Also, months are not capitalized in Spanish, which is why I left them as lowercase.

[-Queue-]

Note that you could make Choose( (Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MonthName(BirthDate), 3 ), 0, 1 ) + 2) / 3 - 1, "enero", "febrero", marzo", "abril", "mayo", "junio", "julio", "agosto", "septiembre", "octubre", "noviembre", "diciembre" ) its own calc and then each instance of conversion would only require

PositionCalc & " " & Day(BirthDate) & " de " & Year(BirthDate)

Also, months are not capitalized in Spanish, which is why I left them as lowercase.

[Ugo DI LUCA]

Actually, "March 11, 2005" should convert to "11 de marzo 2005"

[Ugo DI LUCA]

Actually, "March 11, 2005" should convert to "11 de marzo 2005"

[Ugo DI LUCA]

Actually, "March 11, 2005" should convert to "11 de marzo 2005"

[-Queue-]

Good call. I wasn't paying attention to the formatting.

Day(BirthDate) & " de " & MonthCalc & " " & Year(BirthDate)

[-Queue-]

Good call. I wasn't paying attention to the formatting.

Day(BirthDate) & " de " & MonthCalc & " " & Year(BirthDate)

[-Queue-]

Good call. I wasn't paying attention to the formatting.

Day(BirthDate) & " de " & MonthCalc & " " & Year(BirthDate)

[bloop]

While we're on the sabject of Spanish, would anybody have a formula for putting Spanish numbers into letters. I'm trying to help an acquaintencne to get her invoicing system up to date ?

Thanks,

Geo

[comment]

That's a very generous "while", considering the time elapsed...

See if this helps.

[bloop]

Thanks for your message. My request was - & still is - for Spanish; I saw noting on the "here" button ...

[comment]

Nothing?

[Lee Smith]

That's strange?

What do you mean there wasn't any thing there. I used comment's link that he labeled "[color:red]This" and it contained a lot of information. BTW, I don't see a [color:red]here anywhere?

Lee

[bloop]

I'm sorry. Lee, for the misunderstanding ! ! All I asked for was a number to word formula in Spanish ...

Geo.

[comment]

I really don't know what to say. The thread I linked to has at least two versions of such formula. Short of gift-wrapping them and hiring a clown to deliver them to your house, I can't see how I can help you further.

[Inky Phil]

As the content of some of my answers would indicate, I have a number of clown costumes that you can borrow should you wish to save a little money on the carriage charges

:party:

[comment]

Perhaps we could start a singing-formula-gram service:

"All your worries, gone and banished -

here's your formula in Spanish!"

[LaRetta]

We could include the Break-Your-Calc-While-You-Wait service as well!

In all fairness, maybe they didn't see that there are two pages to that thread. The Spanish calcs are on page 2.

LaRetta