HI,

Need to convert Date in "Datemodified" Column of the recordset(RsCSV)
         Example date 11/30/1901  need to change to 11/30/2001
                     There is only 2 values like this that need changed
(Just the YEAR needs to be changed)
                                   1901 to 2001 and 1902 to 2002

   I guess I need to loop through the recordset? And how do I change the
value in
the recordset?

 'Modify data in Recordset
     RsCSV.MoveFirst

     Do Until RsCSV.EOF

               RsCSV("Datemodified") = ?

      Loop

Thanks for any help
GV

You could use the DateAdd function and add 100 years to the date if the year
is < 1903

RsCSV("Datemodified") = DateAdd("yyyy",100,RsCSV("Datemodified") )

-David