GetSQLDate ( text )

Converts Dates returned by the ExecuteSQL function from YYYY-MM-DD to locale date format

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

Andrew Duncan - Show more from this author
Databuzz
https://www.databuzz.com.au

Sample input:

GetSQLDate ( "2015-01-30" )

Sample output:

30/01/2015 for locate set to DD/MM/YYYY

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

Let ( [ 
	t1 = text ; 
	t2 = Substitute ( t1 ; "-" ; ¶ ) ;

	yyyy = GetValue ( t2 ; 1 ) ;
	mm = GetValue ( t2 ; 2 ) ;
	dd = GetValue ( t2 ; 3 ) ;
	sep = "/"

] ; 

Date ( mm ; dd ; yyyy )



) // Let

Converts Dates returned by the ExecuteSQL function from YYYY-MM-DD to locale date format. ExecuteSQL accepts only the SQL-92 syntax ISO date and time formats with no braces. Dates are returned as text strings in this format:

YYYY-MM-DD

Comments

		comment, VR Jun 1, 2015
This is assuming that the date format in use is d/m/y. In order to make the calculation indpendent of any locale settings, use the Date() function instead, for example: Let ( [ ymd = Substitute ( text ; "-" ; Â¶ ) ; year = GetValue ( ymd ; 1 ) ; month = GetValue ( ymd ; 2 ) ; day = GetValue ( ymd ; 3 ) ] ; Date ( month ; day ; year ) )

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

GetSQLDate ( text )

Comments

Support this website.

Support this website.