AnsweredAssumed Answered

Find/Replace Date

Question asked by Terri on Apr 27, 2012
Latest reply on Apr 27, 2012 by philmodjunk


Find/Replace Date



I have a date in a field (each record has a different date) formatted as 02/12/2011. I want to change all dates that end with 2011 to 2012 and all dates that end with 2012 to 2013. Basically I've duplicated all my records from one year to the next but I need that date to move forward as well. Find/replace doesn't seem to work. I use *2011 because the entire contents of the field are not just the year and it appears to run through all the fields, but the year does not change.

Any ideas?