note
TedPride
How about:<br>
<code>SELECT SUBDATE(datefieldname, INTERVAL 13 MONTH);</code><p>
You can then format the result as needed with DATE_FORMAT(). I'm willing to bet both processes will be more efficient done through database than Perl.<p>
EDIT: Oops - as pointed out by [grinder] in PM, he already specified that the database approach wouldn't work, since the field is TEXT. Somehow I missed that. Whoever designed the table needs some serious punishment.
517745
517745