English SQL reference guide reads this DATEVAL('2019-01-30') returns 2019-01-30
French SQL reference guide (https://fmhelp.filemaker.com/docs/16/fr/fm16_sql_reference.pdf ) reads that :
DATEVAL('2019-01-30') renvoie 30/01/2019
I wish the french documentation were right, because that would be a cool behavior, as it would help this Improve ExecuteSQL Date and Timestamp handling tremendously (effectively delivering second sub-idea)
But unfortunately ExecuteSQL DATEVAL('2019-01-30') returns 2019-01-30 on french OS, and not 30/01/2019 as told by the french documentation.
I would prefer a bug fix, rather than a documentation fix (if so do the same with TIMESTAMPVAL, where french documentation is less wrong but ambiguous, but less useful).
Also, one (and I do) could question the worthlessness of a function that returns exactly what's being impute. f(a)=a is useless, so is DATEVAL('2019-01-30') = 2019-01-30. Those DATEVAL and TIMESTAMPVAL functions should return Filemakers native date and timestamp format of the current OS settings. Like discusses here Improve ExecuteSQL Date and Timestamp handling