I was not the original person to create this.

The table with the date field is found on an Access database.

I have a macro that imports a .csv file with all the information and places it into that table.

The date field is originally set as a Text field, so when you look at the dates in the table they look like this...
1_/1_/2007
2_/16/2007

They recently asked to have the report sorted by date, but when I tried it wouldn't work.

So, when I saw the field set as text I decided to change it to Date type so the sorting would work properly. After setting the field as a Date type the dates in the table look like this...
_1/_1/2007
_2/16/2007

See the difference? Now, when the Crystal Report is run the error occurs. The error says "Bad Date Format String."

This is the coding used in the formula in Crystal...

Code:
IF DATEVALUE({Tbl-Pending_Cancels-Current.Pend Date})+30<CurrentDate+7
THEN "FINAL NOTICE"
ELSE

if{Tbl-Pending_Cancels-Current.New}<>"NEW"
THEN "FOLLOW UP NOTICE"

ELSE

 ""