1 Reply Latest reply on Apr 27, 2012 8:27 AM by philmodjunk

    Find/Replace Date



      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?

        • 1. Re: Find/Replace Date

          Find/replace is intended for modifying text. While dates may look like text, a date is actually stored as a number that records the number of days from 12/31/0000 to the date you see in the field.

          Try using Replace Field contents with this calculation:

          Date ( Month ( yourDateField ) ; Day ( YourDatefield ) ; Year ( YourDatefield ) + 1 )