I will read that as records with a date that is 14 days in the future.
Get ( currentDate ) + 14
will compute a date 14 days in the future.
That could be part of a find in a date range, with an inequality operator or just by itself depending on what results you want from your find.
Here is a thread with multiple scripted find examples you can look at to see how this can work: Scripted Find Examples
Thank you so much for the quick response! I'll use that as a guideline and if I have further questions I'll let you know.
All that worked perfectly, thanks again so much!
I was having an issue with modifying the script to display records with a date field whose date is ≤ 14 days in the future
Get ( CurrentDate ) ≤ 14 is what I used for the expression, and it didn't work.
If you are using a set field step to specify find criteria in a scripted find, you'd use:
Set Field [ YourTable::YourdateField ; "<" & Get ( currentDate ) + 14]
to find all records with dates older than 14 days in the future.
Thank you so much for your patience with my vague explanations. You guessed correctly- I was using a set field step to specify find criteria in this scripted find. Below is the script I got using the scripted find examples you provided. Everything worked perfectly when I had the set field step as: Set Field [Logistics::Start Ship Date; Get ( CurrentDate ) + 14]; however, once I changed it to: Set Field [ YourTable::YourdateField ; "<" & Get ( currentDate ) + 14] , it no longer worked properly. I realize that there might be an error with the If/End If step, but I need some guidance on how to fix that if that is the error causing the script to not run properly.
Go to Layout ["Log1" (Logistics)]
Enter Find Mode 
Set Field [Logistics::Start Ship Date; "≤" & Get ( CurrentDate ) + 14]
Set Error Capture [On]
Perform Find 
If [not Logistics::Start Ship Date ≤ Get ( CurrentDate ) + 14 // no records were found ]
Show Custom Dialog ["ERROR"; "No Records were found by this search."]
How exactly does it fail to work? Do you get no records found or the incorrect records found?
Since specifying Get ( CurrentDate ) + 14 works for you, I suspect that it is actually working but not producing the results you wanted.
If today is 3/1/2013 you had these dates in the Start Ship Date field:
3 / 17 / 2013
3 / 16 / 2013
3/ 15 / 2013
3/ 1 /2013
Any records with the dates shown in blue would be found as these are all records whith a date that is 3/15/2013 or less.
I get no results found (the Show Custom Dialog step creates the dialog box with the error message). I even entered test records with the start ship date field set to some of the dates that should work and it did not.
And my apologies... I made a mistake when explaining the range of dates I needed to include. It should be 14 days in the future from the current date or earlier, but not before the current date. Does that make sense?
Make sure that Start Ship Date is defined as a date field. This sounds like it is actually defined as a text field.
If you have a date field and not text, this expresion should find all records from todays date to 14 days in the future:
Set Field [Logistics::Start Ship Date; Get ( CurrentDate ) & "..." & Get ( CurrentDate ) + 14]
Huzzah! It worked :) Thank you so much! I appreciate all of your help.