Get ( CurrentDate )
Get ( CurrentDate ) + 1
Get ( CurrentDate ) + 7
Ah! Thank you.
Here's my new issue....
Using a Trigger to run the script:
If [Stock Transactions::Sort Selection = "Due Today"]
Find Matching Records [Replace; Stock Transactions::Orders_Today]
Go to Record/Request/Page [First]
Where "Orders_Today" is an indexed calculation field with the statement: Get (CurrentDate) = OrderDate
When I ran this script for the first time, it worked. Awesome! The script returned all the records that matched "Orders_Today." Just as if I had typed todays date and searched via the toolbar. Lets just say it showed the 2 records of 200 that fit the argument.
Every time after that, I get the exact opposite. The script returns 198 records and leaves out the 2 matching ones.
Thank you again.
Calculation fields that use a Get function must be unstored and by definition, these are not indexed. Otherwise, they will not correctly update when the date returned by your system clock changes.
I'd use one of the scripted find examples found Here: Scripted Find Examples
To find all records with Today's, Next week's, etc dates.
Thank you so much...again.
I look forward to repaying the help to someone else in the future.
With some tweaking of the scripts in the link you posted, I got exactly what I was looking for. Thank you again, for you help and tips.