Search Current Date within field in Record Selection

[Heath0814]

Hello,
I'm writing a report where I only want to display records that have a date within the past week in the field called AuditTrail. There is numerous other information in the AuditTrail field, so I need to search within the field. Thus, if the AuditTrail has *09/28/11* in it, the record would display, but if it had *08/20/10* it wouldn't. I need to automate this report, so I can't list the dates. I tried using CurrentDate, but it looked for the word CurrentDate instead of the date. What can I do?

An example of this data included in this field is below for one record:

Created at 09/28/11 02:02 PM by Lowrance, Stephen
Updated at 09/28/11 02:02 PM by Lowrance, Stephen
Changed MSR Deliverable % Complete [Custom field] from "0" to "39"
Updated at 09/28/11 04:13 PM by DiNardo, Lori
Changed Resolution notes [Text field]
Changed MSR Deliverable % Complete [Custom field] from "39" to "90"
Changed Issue notes [Text field]
Updated at 09/29/11 09:08 AM by Lowrance, Stephen
Changed Assigned to from "Lowrance, Stephen" to

 

[lbass]

stringvar array y := split({table.field," ");
numbervar i;
numbervar j := ubound;
booleanvar z := false;
for i := 1 to j do(
if isdate(y) and
date(y) in currentdate-6 to currentdate then
z := true
);
z = true //for a selection formula

-LB