ChangeDate_SQL_to_FM ( Fecha )

Convert format date from SQL to FileMaker format

Average rating: 5.0 (1 vote) Log in to vote

Jesus Sanchez - Show more from this author
dbFile Desarrollos
http://www.dbfile.es

Sample input:

ChangeDate_SQL_to_FM ( 2019-03-31)

Sample output:

31/03/2019

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

/**
* =====================================
* #ChangeDate_SQL_to_FM ( Fecha )
*
* DEVUELVE:
*		La fecha recibida en formato FileMaker  ( DD/MM/AAAA )
*
* PARAMETROS:
*		Fecha: Fecha en formato SQL.
*
* EJEMPLO:
*		ChangeDate_SQL_to_FM ( 2019-03-31)
*		Resultado: 31/03/2019
*
*
* DEPENDENCIA: Ninguna
*
* HISTORIA:
*		CREADO el 17/09/2018 por Jesus Sanchez [ dbFile Desarrollos].
* =====================================
*/



Let ( 
[
Fecha = Fecha ;
Fecha = Substitute ( Fecha ; "-" ; "¶" ) ;

dia = GetValue ( Fecha ; 3 );
dia = Filter ( dia ; "1234567890" ) ;
dia = Right ( "0" & dia ; 2 );

mes = GetValue ( Fecha ; 2 );
mes = Filter ( mes ; "1234567890" ) ;
mes = Right ( "0" & mes ; 2 ) ;

Anyo = GetValue ( Fecha ; 1 );
FechaFM = Date ( mes ; dia ; Anyo )

]
; FechaFM

)

Change a date in SQL format to FileMaker format.

See also :
ChangeDate_FM_to_SQL
and
ChangeDate_FM_to_SQL__TimeStamp

Comments

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

ChangeDate_SQL_to_FM ( Fecha )

Comments

Support this website.

Support this website.