Crystal Reports Number to Date

Message

     Hi,

Our current system reports date is the format CYYMMDD and crystal pull sthis through as a number. We initiaaly used this formula

date ((if left (totext({file.date}),1) = "1" then "20" else if left (totext({file.date}),1) = "0" then "19") & 
(mid (totext ({file.date}),3,2)) & "," & 
(mid (totext ({file.date}),5,1)) &
 (mid (totext ({file.date}),7,1)) & "," & 
(mid (totext ({file.date}),8,2)))

and then our database was updated (No Idea how as iseries databases do not update anything). This caused is to get the 'Bad Date Format String' error. So then we started using the following

if len(totext({file.date})) > 10 then date ((if left (totext({file.date}),1) = "1" then "20" else if left (totext({file.date}),1) = "0" then "19") & 
(mid (totext ({file.date}),3,2)) & "," & 
(mid (totext ({file.date}),5,1)) &
 (mid (totext ({file.date}),7,1)) & "," & 
(mid (totext ({file.date}),8,2)))

Now our database has updated again and this comes up blank. Does anyone know how to correct this as we've got around 70 reports that we can no longer run. Any help would be GREATLY appreciated!!