What defines a record from 1 year ago, creation date? Or the last time some sort of service was provided. Do you want exactly 1 year ago, less 14 days?
Some examples: Today is June 14, 2014. Show me all the records from June 28, 2013? Or show me all the records up to June 28, 2013? Or show me all the records between June 14, 2013, & June 28, 2014?
Some more info will help get a better response.
A simple formula like Get(CurrentDate) -341 may help (365-14 equals the 341).
Something even easier is, if you can perform the find manually, when you script it, it's usually there in the perform find calc.
That was way too simple. Thanks for the help.
It ends up looking something like this. SetVariable &&Two Weeks Out [Get(CurrentDate)-365 &"..." & Get(CurrentDate)-341]
This variable can be placed into any search in a script for the result I need. I was just over thinking how to calculate the dates I needed, didn't realize FMPro would subtract from dates in that manor.
You may also want to script your finds using Set field steps as shown in the examples here: Scripted Find Examples
That makes it easier to tell what search criteria was used should you later return to this script and need to see what was used in the performed find.