AnsweredAssumed Answered

TIMESTAMPVAL and DATEVAL functions in SELECT clause in executesql do not work

Question asked by larryw on Feb 2, 2014
Latest reply on May 12, 2015 by TSGal

Summary

TIMESTAMPVAL and DATEVAL functions in SELECT clause in executesql do not work

Product

FileMaker Pro

Version

13

Operating system version

OSX Mavericks

Description of the issue

Attempting to use DATEVAL and TIMESTAMPVAL in Select clause of select statement within EXECUTESQL function. Neither are recognized as executesql returns a '?'.

Example query:
select dateval('2012-01-01')
from z_ten

Where z_ten is a table contains 10 rows.

In contrast:
select current_date, current_timestamp, current_time
from z_ten

does execute correctly

Steps to reproduce the problem

Enter the above two queries in a simple test harness.

Expected result

The value '2012-01-01' repeated ten times

Actual result

?

Workaround

None

dateval.png

Outcomes