In File Options, you can designate a script to be performed every time you open the file.
This script can perform a find for the records that are 3 days or more older than today. If any are found, it can display a message in a custom dialog and also present you with a list of the records found.
You'll likely want to add another field where you can check off the records where you've followed up so that you can include this field in your find. That way, you won't keep getting the same record popping up after you've finished the follow up task.
How would i do this. im really clueless with dates and all that stuff
I'm assuming you know how to use File Options to perform this script.
Your script might look like this:
Go To Layout [select a layout based on the table where you have this date field defined]
Enter Find Mode  // clear the pause check box
Set Field [YourTable::YourDateField ; "≤ " & Get ( CurrentDate ) - 3 ]
Set Field [YourTable::DoneStatus ; "="] // a lone "=" like this specifies records where this field is empty
Set Error capture [on] //keeps "no records found" dialog from interrupting script if no records are found
Perform Find  // do not specify criteria in this step.
If [Get ( FoundCount ) ]
Show Custom Dialog ["These records still have not been followed up."]
Go To Layout [select the layout you want users to see if there are no follow up records to deal with]
following your script to a T and it says im missing an operator get current date
Do you see an extra set of  not shown in my script example?
When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Click OK. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.
If not, please post exactly what you have and I'll take a closer look at it.
Thanks alot phil once again greatly appreciated.