ConvertExecuteSQLDateAU ( text )
Converts Dates returned by the ExecuteSQL function from YYYY-MM-DD to DD/MM/YYYY
Average rating: 4.5 (24 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Converts Dates returned by the ExecuteSQL function from YYYY-MM-DD to DD/MM/YYYY. ExecuteSQL accepts only the SQL-92 syntax ISO date and time formats with no braces. Dates are returned as text strings in this format:
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.