AnsweredAssumed Answered

Scripted find on date field using the format DD/MM/YYYY

Question asked by ytrejbal on Sep 1, 2014
Latest reply on Sep 2, 2014 by ytrejbal

Summary

Scripted find on date field using the format DD/MM/YYYY

Product

FileMaker Pro

Version

13.0v3.0

Operating system version

OSX 10.9.4

Description of the issue

Trying to perform a find on a date field using the following script steps:

Enter Find Mode []
Set Field [Tablename::Datefield; "28/03/2013"]
Perform Find []


I have also tried to use

Set Field [Tablename::Datefield; GetAsDate("28/03/2013")]

And it returned the dame error as described below.


This error is also occurring in FileMaker 12.0v5

Steps to reproduce the problem

To recreate the issue create a script with the lines about and a table with an indexed date field. Populate the table with a number of records with varying date ranges but make sure that some have the date 28/03/2013

Expected result

Return found set of records with date 28/03/2013

Actual result

Error 500 on setting of date field to 28/03/2013 and an error message asking to provide valid criteria.

Exact text of any error message(s) that appear

The provided find criteria is not valid. ether a valid request before proceeding.

Configuration information

FielMaker is installed on a Apple MacBook Pro running OSX 10.9.4.
Data Entry setting is set to "Always use current system settings".
Date field is indexed

Mac OSX Language & Region setting is:
Region Australia,
First day of Week Sunday
Calendar Gregorian
Date format is set to DD MM YYYY

Workaround

The work around is to use American date formatting. But our business works on Australian/European date formatting. So this is not a solution for us going forward.

Outcomes