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

Reply via email to