main logo
Subject: Re: year portion of date field
Author: Todd Haehn
Posted: 2002/10/14 18:42:11
 
View Entire Thread
New Search


<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
<-- Prior Message New Search Next Message -->