Newest functions Upload a function Leave a tip My account

There are 2,525 functions in this library.

ChangeDate_FM_to_SQL ( Fecha )

Convert format date from FileMaker to SQL format

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

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

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

/** * ===================================== * #ChangeDate_FM_to_SQL ( Fecha ) * * DEVUELVE: * La fecha recibida en formato SQL ( AAAA - MM - DD ) * * PARAMETROS: * Fecha: Fecha en formato FileMaker. * * EJEMPLO: * ChangeDate_FM_to_SQL ( 25/03/2019) * Resultado: '2019-03-25' * * * DEPENDENCIA: Ninguna * * HISTORIA: * CREADO el 17/09/2018 por Jesus Sanchez [ dbFile Desarrollos]. * ===================================== */ Let ( [ Fecha = Fecha ; dia = Day ( Fecha ); dia = Filter ( dia ; "1234567890" ) ; dia = Right ( "0" & dia ; 2 ) ; mes = Month ( Fecha ); mes = Filter ( mes ; "1234567890" ) ; mes = Right ( "0" & mes ; 2 ) ; Anyo = Year ( Fecha ); FechaSQL = Anyo & "-" & mes & "-" & dia ] ; "'" & FechaSQL & "'" ) Click to copy

Change a date in FileMaker format to SQL format.

See also :
ChangeDate_SQL_to_FM
and
ChangeDate_FM_to_SQL__TimeStamp

 

Comments

		KC Sep 10, 2020
This is what I am looking for comparing date result, It works perfectly! Thanks bro

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: