Scripted find on date field using the format DD/MM/YYYY
Operating system version
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
Return found set of records with date 28/03/2013
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.
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:
First day of Week Sunday
Date format is set to DD MM YYYY
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.