title: DBASE Command Line to Replace a Year in Date Field
body: <p>I am working in a software program called PastPerfect that has a "command window" where it says you can use dbase commands to do global updates to the program's dbf files. </p>
  
  <p>THE PROBLEM: a user accidentally entered the wrong year, "1901", in a date field across multitudes of records and it needs to be replaced/fixed with the year "2001".</p>
  
  <p>I have tried: </p>
  
  <blockquote>
    <p>REPLACE YEAR(catdate) WITH 2001 FOR YEAR(catdate)=1901 </p>
  </blockquote>
  
  <p>and it keeps telling me it is an <code>Invalid Command</code></p>
  
  <p>Can somebody give me the correct dbase/foxpro syntax to replace all the years that are 1901 with 2001?</p>