_SqlTS_To_FilemakerTS ( pTS )

Converts a ExecuteSQL timestamp to a valid FileMaker timestamp

Average rating: 4.5 (29 votes) Log in to vote

Joerg Koester
jk-solution
http://jk-solution.net

Sample input:

_SqlTS_To_FilemakerTS ( "2013-07-20 22:37:10" )

Sample output:

20.07.2013 22:37:10
for Europe

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

/*
Name:	_SqlTS_To_FilemakerTS ( pTS )
Param:	pTS
Return:	(timestamp)
--------------------------------------------------------------------------------
Author:	Joerg Koester
Version:1.0
Created:20.07.2013
--------------------------------------------------------------------------------
Description:converts a ExecuteSQL timestamp to a valid FileMaker timestamp 
--------------------------------------------------------------------------------
*/

Let ( [
	vSplit	= Substitute ( pTS ; " "; ¶ ) ;
	vDate	= Let (  _date = Substitute ( GetValue ( vSplit ; 1 ) ; "-"; ¶ ) ;
				Date ( 
					GetValue ( _date ; 2  ) ; 
					GetValue ( _date ; 3  ) ; 
					GetValue ( _date ; 1  )
					 ) // end date

				) 
	] ; //end vars
Timestamp ( vDate ; GetValue ( vSplit ; 2 )  )
)

Converts a ExecuteSQL timestamp
"2013-07-20 22:37:10"
to a valid FileMaker timestamp
20.07.2013 22:37:10 (german example)
based on function => Date ( month ; day ; year )

Comments

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

_SqlTS_To_FilemakerTS ( pTS )

Comments

Support this website.

Support this website.