Do you want to do this by hand or in a script? The basic process is the same, but the details in how we implement it vary a bit.
enter find mode and enter 9/1/2010...5/12/2011 in your date field
Perform the find
Use Delete Found Set to delete the records
Note: be careful when deleting records. Making a back up copy of your file before you do this is a good idea. Check for any related records that may be deleted automatically and be sure that they should also be deleted. If not, you'll need to either disable this relationship setting or first modify the records so that they are no longer related before deleting them.
Some developers "mark" records as deleted instead of physically deleting them. Then they structure their interface so that such "deleted" records are hidden from the user. This enables the "deleted" record to be brought back if it turns out the record was deleted by mistake.
I want the user to have the option of putting in any date that they want via script. So you would have pop up box when you click on delete records. input buth your date range and then hit delete records.
Use two global date fields for inputting the date range, then your script can use them to construct your find:
Simple script version:
Show Custom Dialog ["Enter deletion dates"] // use input fields to gDate1 and gDate2 date fields that have global storage specified
Enter Find Mode  //clear pause check box
Set Field [Yourtable::DateField ; If ( YourTable::gDate2 > YourTable::gDate1 ; YourTable::gDate1 & "..." & YourTable::gDate2 ; YourTable::gDate1 ) ]
Set Error Capture [on]
Perform Find 
If [ Get ( FoundCount ) > 0 ]
Delete All Records
Note: the If steps are not needed if you use Delete All records with the No Dialog option.
I prefer a more complex approach that uses New Window instead of Show Custom Dialog as I can then pop up a window with fields that are formatted with drop down calendar controls for entering the dates, but the same basic outline is used.
Edit note: added missing & to above script.
I have a creation date already built on the form. That currently is what processes the date on the records. How would i incorporate that ?
Subsitute your table and field names for mine as needed to get the script to work.
Where I have YourTable::DateField, you'd use the table occurrence name and date field name from your database to refer to the createion date field.
Set Field [Yourtable::DateField ; If ( YourTable::gDate2 > YourTable::gDate1 ; YourTable::gDate1 & "..." YourTable::gDate2 ; YourTable::gDate1 ) ]
After "..."YourTable::gDate2 ; Says i need anoperator charector after gdate2
i posted the screen shot
looks like you need an & between "..." and your date 2 field
Im lost now aammondd. so i take the ... dots out?
Good catch! That & is missing from my original script example and Ray Zuchowski has then replicated my mistake.
If (Pre Screen App Main::gDate1 > Pre Screen App Main::gDate2;Pre Screen App Main::gDate1 & "&" & Pre Screen App Main::gDate2 ;Pre Screen App Main::gDate1 )
Thats what i have now but the script doesnt work. It cleared the error though.
the ... should have & on either side
date1 & "..." & date2
You need to have one between any two things you are trying to cocatenate (string together)
Check out the original script, I've edited it to correct the error, so you can compare your expression to it to see the correct syntax here.
I updated my screen shot. However it still doesnt work... Phill hellppppppp! lol also i dont see anything in the script that sets the action of the OK and Cancel button for the pop up dialog.