AnsweredAssumed Answered

ExecuteSQL DateVal is buggy or french documentation is wrong

Question asked by Vincent_L on Jun 16, 2018
Latest reply on Jun 21, 2018 by TSGal

Hi,

 

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

 

 

Outcomes