<i><font color="#663300">How can i replace the year portion of a date field and the year portion of a date variable</font></i>
Convert it to a string and replace the year in the string, then convert it back to a date like this: CTOD(STRTRAN(DTOC(DATE()),'2002','2004'))
Todd Haehn ©2002 Todd Haehn |