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

    Find/Replace Date

    Terri

      Title

      Find/Replace Date

      Post

      Hi,

      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
          philmodjunk

          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 )