Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

ChangeDate_FM_to_SQL__TimeStamp ( FechaHora )

Change data format from FileMaker TimeStamp 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__TimeStamp ( FechaHora ) * * DEVUELVE: * La fecha recibida en formato SQL ( AAAA-MM-DD HH:MM:SS ) * * PARAMETROS: * FechaHora: Fecha en formato FileMaker. * * EJEMPLO: * ChangeDate_FM_to_SQL__TimeStamp ( 17/09/2018 17:53:06 ) * Resultado: '2018-09-17 17:53:06' * * * DEPENDENCIA: Ninguna * * HISTORIA: * CREADO el 17/09/2018 por Jesus Sanchez [ dbFile Desarrollos]. * ===================================== */ Let ( [ Fecha = GetAsDate ( FechaHora ) ; 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 ; Hora = GetAsTime ( FechaHora ) ] ; "'" & FechaSQL & " " & Hora & "'" ) Click to copy

Change a TimeStamp in FileMaker format to SQL format.

See also :
ChangeDate_FM_to_SQL
and
ChangeDate_SQL_to_FM

 

Comments

		KHALID SAID , K.D May 3, 2020
Hello my brothers I want help with this function ................ Is it possible to have the function automatically calculate the age by day, month and year I mean with every new day the date of birth changes .. Of course, with the history of the computer changed Thank you ــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ Let ([ today = Get ( CurrentDate ) ; days = today - birthdate ; md = Date ( 0 ; days + 1 ; Year ( birthdate ) ) ; y = Int ( days / 365 )]; y & " years, " & Month ( md ) & " months, & " & Day ( md ) & " days" )

		Jesus Sanchez, dbFile Desarrollos May 4, 2020
Thank you for your comment Khalid, you can create a custom function with this one, it will be easier to locate if it is a new function than if it is in the comments of another. Best regards.

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: