With FM6, you will need to set a global text field to your calculation (">"
& Today-365"). (I would suggest using Status(CurrentDate) instead of Today)
Then use the copy step (select the global field) and paste step (Select the
Date field) into your Date field. You have to be on a layout with the copy
& paste fields present for the copy paste to work.
So your script would look something like this-
Go to layout "all fields" (this is a layout with all of your fields- or the
ones you need for this script)
Set Field ["global", ">"& (StatusCurrentDate-365)]
Copy [Select, global]
Paste [Select, Date]
Perform Find [Replace Found Set]
Go to layout original
Hope this helps,
Martina
> Enter Find Mode[]
> Set Field ["Date",( "">" & Today-365")]
> Perform Find [Replace Found Set]
> 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
