The Insert Calculated Result is the ticket!
Many thanks!
Jay
On Dec 28, 2008, at 10:43 PM, Jason L DeLooze wrote:
Jay,
Use "Insert Calculated Result" to place the criteria into the Date
field.
Enter Find Mode []
Insert Calculated Result [ "Date" , "> " & DateToText( Today- 365 ) ]
Perform Find [Replace Found Set]
etc
Best wishes,
Jason L. DeLooze
Annapolis, MD USA
On 12/28/08 at 8:48 PM -0500, Jay Erlebacher wrote:
Can someone help with this seemingly trivial problem?
This is maddening.
I can do a manual date find like >12/29/2007 with no problem.
But when I script a find like this:
Enter Find Mode[]
Set Field ["Date",( "">" & Today-365")]
Perform Find [Replace Found Set]
The ">" doesn't show up. Only the year ago date goes into the find.
This seems like something very elementary, just finding a range of
dates.
What the heck am I missing?
Jay