GetAs ( type ; value )

Dynamic GetAs function for all data types (text, number, date, time, timestamp)

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

Ethan - Show more from this author
Tactile Medical
https://www.linkedin.com/in/ethyoder

Sample input:

Input 1: GetAs ( "Date" ; "06/24/2021 01:24:20 PM" )
Input 2: GetAs ( "Number" ; "HGFS83423F34SD9" )

Sample output:

Output 1: 6/24/2021
Output 2: 83423349

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

//	NAME		GetAs
//	DESCRIPTION	Returns a piece of text as the type given
//
//	PARAMETERS	type (text): the type you want to turn the value into. Check RETURNS section for passable values.
//			value (any): the value you want to transform
//
//	RETURNS	text, number, date, time, timestamp
//
//	EXAMPLE	GetAs ( "Date" ; "06/24/2021 01:24:20 PM" )
//	RESULT		6/24/2021
//
//	DEPENDENCIES	<<none>>
//
//	2021-10-27, eyoder, Created CF


Let ([

	vType = type ;
	vValue = value

];

	Case (
		vType = "Text" ;
		GetAsText ( vValue ) ;

		vType = "Number" ;
		GetAsNumber ( vValue ) ;

		vType = "Date" ;
		GetAsDate ( vValue ) ;

		vType = "Time" ;
		GetAsTime ( vValue ) ;

		vType = "Timestamp" ;
		GetAsTimestamp ( vValue ) ;

		// ELSE
		vValue
	)
)

Takes in a value and the type you want to transform it into. Works with text, numbers, dates, times, and timestamps. Useful for when you need to change a variable into a data type dynamically.

Comments

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

GetAs ( type ; value )

Comments

Support this website.

Support this website.