Brian Dunning's FileMaker Custom Functions

solfm_fechaPalabras

Converts dates to word (in spanish) - Convierte fechas a palabras en castellano

  Average rating: 4.6 (31 votes) Log in to vote

Diego D'Alessio   Diego D'Alessio
Soluciones Filemaker
http://www.solucionesfilemaker.com

Share on Facebook Share on Twitter

  Sample input:
solfm_fechaPalabras (fecha)
  Sample output:
Sábado, 7 de Julio de 2011

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Converts dates to word (in spanish) - Convierte fechas a palabras en castellano.

 

Comments

Daniele Raybaudi   Daniele Raybaudi, ACI
Jul 8, 2011
Couldn't you use the DayName and MonthName functions ?
 
Diego DAlessio   Diego DAlessio, Vicente Lopez
Jul 9, 2011
I need it to be OS Language independent and be SURE it will display the information in Spanish.
 
Daniele Raybaudi   Daniele Raybaudi, ACI
Jul 9, 2011
diaNumero = Day ( fecha )

must be:

diaNumero = DayOfWeek ( fecha )

BTW: another calc could use the Choose ( ) function:

Choose (
DayOfWeek ( fecha ) ; ""
; "Domingo"
; "Lunes"
; "Martes"
; "Miércoles"
; "Jueves"
; "Viernes"
; "Sábado"
)

& ", " & Day ( fecha ) & " de " &

Choose (
Month ( fecha ) ; ""
; "Enero"
; "Febrero"
; "Marzo"
; "Abril"
; "Mayo"
; "Junio"
; "Julio"
; "Agosto"
; "Septiembre"
; "Octubre"
; "Noviembre"
; "Diciembre"
)

& " de " & Year ( fecha )
 
Diego DAlessio   Diego DAlessio, Vicente Lopez
Jul 9, 2011
Sweet. All roads go to Rome :)
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.