I'm working towards a solution for a question i have and now i'm trying to make a find script.
When i use PerformFind and say Find Records where date is less than 31-01-2016 that works like a charm
But when i try to do the same find with "Perform Quick Find" and say "date < 31-01-2016" it comes back with only dates from january. What am i doing wrong here??
Quick Finds do not support operators like that. If you want to perform a find of this nature then your best bet is to use your first example.
See here for more information about Quick Find...
But the plan in the end is to have a field in which the enduser can type in a date and that filemaker performs a find that only shows the record with dates older that the date typed by the enduser. I don't see how i can accomplish that with "specify find request". I ws hoping that i could doit with the quick find since it seemed it let me use operators..
You can accomplish what you want. Create a global date field and the following script:
Enter find mode
set field[ your_date_field;Value: "<" & global date field]
Perform Find . Do not specify a find request
Then use an on exit script trigger to trigger the script after you exit the global date field
I'm trying what you posted but i cannot get it to work.
I've made the global field and named it "GlobalField".
Now i want to make the script but when i put in "test::datum;Value "<" & test::GlobalField" in de calculated result of the "Set Field" it says it is missing an operator. I have the feeling i'm close...
Your calc is wrong. It should just be "<" & test::Globalfield.
Click on Specify target field to enter the test::datum field.
Works like a charm! Thanks!