You'll need a script as you have to either assign the date range text to a variable and then refer to the variable by name in a find with stored criteria or (a much better method), have your script enter find mode and use set field to set up the find criteria.
for examples of the second method, see: Scripted Find Examples
I followed second method, see: Scripted Find Examples
Can I get some clarification:
I moved my fields to globals and selected global for each. I have:
gRangeMonth which is calendar drop down to ask user what month they want to select for
gDateRangeFirstDay - calculated field to give first day of search range
gDateRangeLastDay - calculated field to give last day of search range
Following example post I have script that opens the layout with those three fields on it.
Enter find mode and cleared the box
stuck on set field. what do I use? I am searching for all RecordCreatedDate in my main table between dates set from global table.
The examples are right there in the thread.
Set FIeld [YourTable::RecordCreatedDate ; YourTable::gDateRangeFirstDay & "..." & YourTable::gDateRangeLastDay ]
But there's a simpler way if the date range is always exactly one month.
The find criteria:
for example, will find all records with a date in the month of May, 2015
The third line of my script is supposed to be: Set Field [YourTable::YourField ; Globals::gField]
I add the Set Field and click specify and it only lets me either choose one field. I'm sure the problem is between my keyboard and seat but I cannot clear this hurdle to get to the rest of it.
I absolutely appreciate all you help.
This issue comes up so often that I have a standard response in the Known Bugs List that I copy/paste when it occurs:
When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.